Dansk dato format men hvordan

glem det har formateret en string selv.

dates are always stored in the same way in Access. The PC's regional settings decide hwo you see them.

how are they stored then Terry, isn't yyyy-mm-dd ??

double

try this

in the debug window (Ctrl+G)

enter

?cdbl(now())

then take the part before the .

and write

?cdate(38810)


and then you cantake the  part after the .

and write

?Cdate(0.3850578704)

the time wil ahve changed but its not far out

See what I mean?

so th part before the . is the date an dthe part after the . is the time

is that how it is stored??
mine says 03-04-2006

But if I check that date using if day <= 03-04-2005.... no records are returnen even though if know I have records with a newer date

the way dates are stored (saved) in the database is NOT the same as the we you see it. The PC's regional settings are used to display dates in the correct format. Try and change the regional settings for your PC and you will see what I mean.

ahh, I see but that still doesn't change the fact that i have to use this string to make the right check
niceDate = Year(pay) & "-" & Month(pay) & "-" & Day(pay)

its always a problem working with dates in Access or most other databases for that matter.

You can use Format(pay, "yyyy-mm-dd")