Get DatePart

[Tausif Alam]

Hi All,

I have a field datetime sotres date and time. But whenever I want to comapre
only date part, it does not work in simple way. How can I cmpare date only..

Thankx

 

[Nikos Yannacopoulos]

Try using the Int() function on the Date/Time field.
Date/Time fields are actually numeric fields of type Double, whre the
integer part is the date (starting 01/01/1900), and the decimal part is the
time, so Int() "strips" the time part and returns the date part only.
For instance, Int(Now()) would return today's date, without the time part.

HTH,
Nikos

 

[Michel Walsh]

Hi,


DateValue( ) and TimeValue( ).


Hoping it may help,
Vanderghast, Access MVP