---
title: "Kolla datum i SQL"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/72032-kolla-datum-i-sql"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Eclipse"
published: "2003-03-24T16:05:05.000Z"
updated: "2003-03-24T16:36:09.000Z"
replies: 2
views: 217
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/databaser-sql/72032-kolla-datum-i-sql"
---

# Kolla datum i SQL

## #1 — Eclipse, 2003-03-24T16:05Z

```
SQL = "SELECT s.intID, s.intMenuID, s.strName, s.strRollOver," _
& " s.dteCreated, s.dteViewFrom, s.dteViewTo, s.bolView, s.intSortfield, " _
& " m.intID, m.strName, m.strRollOver, " _
[b]& " (SELECT IF(s.dteCreated <= date(), " _
& " true, false) as bolPublish FROM [" & mySubMenu & "] s, [" & myMenu & "] m  " _
& " WHERE s.intMenuID = m.intID AND s.intMenuID = " & request("menuID") & " ) " _ [/b]
& " FROM [" & mySubMenu & "] s, [" & myMenu & "] m   " _
& " WHERE s.intMenuID = m.intID AND s.intMenuID = " & request("menuID") _
& " ORDER BY s.intSortfield;"
```

Markerad kod fungerar ej.
index.asp?row=0&menuID=1

Permalänk: https://www.webforum.nu/p/72032

## #2 — LarsG, 2003-03-24T16:24Z

If ? Skalär subselect? Access?

```
SQL = "SELECT s.intID, s.intMenuID, s.strName, s.strRollOver," _
& " s.dteCreated, s.dteViewFrom, s.dteViewTo, s.bolView, s.intSortfield, " _
& " m.intID, m.strName, m.strRollOver, " _
& " IIF(s.dteCreated <= date(), " _
& " true, false) as bolPublish " _
& " FROM [" & mySubMenu & "] s, [" & myMenu & "] m   " _
& " WHERE s.intMenuID = m.intID AND s.intMenuID = " & request("menuID") _
& " ORDER BY s.intSortfield"
```

Permalänk: https://www.webforum.nu/p/989890

## #3 — Eclipse, 2003-03-24T16:36Z

Rätta raden

& " IIF(s.dteCreated \<= date(), 'True', 'False') " \_

Jag trodde att IIF var en kvalificerad felstavning...

Det var en luring! :-)

Nu fungerar det i alla fall.

Permalänk: https://www.webforum.nu/p/989905

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/72032-kolla-datum-i-sql