Returning date from date/time function

[Sillygirl]

Is there a way to extract just the date out of time/date field?? Something maybe using format??

 

[combo]

Function DateValue(....) returns date part of date/time argument.

 

[ajdesalvo]

combo is correct, and you are correct, it can also be derived by using the Format function:

Format(Now(),"mm/dd/yyyy&quot

Code on!



Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[beetee]

while we're at it

Fix(now) returns the current year

as does

yearpart = month(now) & "/" & day(now) & "/" & year(now)

 

[kewo99]

The date is the integer part of the date/time value so
Int(<datefield>) will give you just the date.

Ken

 

[beetee]

The trouble with int() is that it rounds the result, creating interesting results when it's after 12:00 PM.

Therefore, use fix().

 

[PaulBricker]

I believe the difference between Int and Fix is how they handle negative numbers. There shouldn't be any issue using either one of them with a date value.

Paul

 

[beetee]

You're right, I stand corrected. I was thinking of cint