---
title: "date problem"
type: "forum-thread"
url: "https://www.webforum.nu/amne/databaser-sql/100933-date-problem"
topic: "Databaser & SQL"
topic_url: "https://www.webforum.nu/amne/databaser-sql"
author: "Jymdis"
published: "2004-04-05T13:09:08.000Z"
updated: "2004-04-05T20:42:11.000Z"
replies: 2
views: 194
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/100933-date-problem"
---

# date problem

## #1 — Jymdis, 2004-04-05T13:09Z

```
Select DISTINCT(datetime) From calender WHERE (adid = 1) AND id IN (select ID from calender where datetime BETWEEN #1/4/2004# AND #31/4/2004#)
```

Varför får jag:

> Line 1: Incorrect syntax near '#'.

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

## #2 — LarsG, 2004-04-05T13:17Z

```
Select DISTINCT datetime 
 From calender 
WHERE adid = 1
 AND datetime BETWEEN '2004-04-01' and '2004-04-31'
```

Vad som är korrekt beror på vilken dbms det gäller.

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

## #3 — Jymdis, 2004-04-05T20:42Z

jepp :)

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

---

Tråden på webben: https://www.webforum.nu/amne/databaser-sql/100933-date-problem