Hi,

I want to display the dates from my database recordsets and view them as separate numbers using the built in object -datepart (works fine!). Then I want to determine if the date is from today, or from yesterday. But the string comparison does not work the way I want it to. Anybody who knows how to pull it of?

Cheers... //Thomas

I'm not sure why you wish to pull the date appart but if you still have a reference to the original date, or can put it back together you can use datediff() function.

x = datediff("d",date1,date2)
this will return the number of days between the dates.
0 means today
1 tomorrow
-1 yesterday
etc



======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

Sorry,
It might be the other way around. (-1 Tomorrow,1 yesterday)
Just try it to see.

======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

You were right. 0 is for today, 1 is for yesterday and -1 is for tomorrow.

Thanks //Thomas