---
title: "cDate fel :/"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/79580-cdate-fel"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "mikul"
published: "2003-06-12T15:25:16.000Z"
updated: "2003-06-13T08:54:24.000Z"
replies: 3
views: 223
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/asp/79580-cdate-fel"
---

# cDate fel :/

## #1 — mikul, 2003-06-12T15:25Z

Nu är jag förvånad :o
Hur jag än gör så blir mitt datum till 12:00:00 AM i stället för ett datum.

```
fromdate = cDate(request.form("fromdate"))
todate = cDate(request.form("todate"))
	
q = "SELECT t1.* " & _
	" FROM apartments t1" & _
	" WHERE not exists ( select * from apartmentbooking as t2 " & _
	" where t1.apartmentno = t2.Rel_ApartmentNO " & _
	" AND (#" & fromdate & "# BETWEEN cDate(t2.startdate) AND cDate(t2.enddate) " & _
	" or #" & todate & "#  BETWEEN cDate(t2.startdate) AND cDate(t2.enddate) )) " & _
	" ORDER BY t1.apartmentno ASC "
```

Jag får som resultat:

```
SELECT t1.* FROM apartments t1 WHERE not exists ( select * from apartmentbooking as t2 where t1.apartmentno = t2.Rel_ApartmentNO AND (#12:00:00 AM# BETWEEN cDate(t2.startdate) AND cDate(t2.enddate) or #12:00:00 AM# BETWEEN cDate(t2.startdate) AND cDate(t2.enddate) )) ORDER BY t1.apartmentno ASC
```

Vad kan jag ha gjort för fel?

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

## #2 — mikul, 2003-06-12T16:13Z

löste sig :D

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

## #3 — @nders, 2003-06-12T16:14Z

mikul, man skall alltid berätta om sina extrema klantigheter, så andra kan skratta åt dig i all evinnerlighet! ;)

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

## #4 — mikul, 2003-06-13T08:54Z

Hehehe, jag vågar faktiskt inte den här gången :OO

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/79580-cdate-fel