Need to Log DATE ONLY....use Datetime() ????

[kev100]

I've been using:

end_date = Datetime()

To log the date only (it was returning 3/5/2007 only).

After a recent upgrade...the same command is now returning date AND time (as in "3/5/2007 12:34:15 PM")

Is there a variation of Datetime() that will return only the date....as in "3/5/2007" ?

Thanks very much.

 

[mmerlinn]

Check documentation on DATE() to see if that will help you.


mmerlinn

"Political correctness is the BADGE of a COWARD!"

 

[kev100]

DOH!

You're right.

I didn't ref docs...but did find it in some other coding.

For anyone referencing this.....

end_date = DTOC(Datetime())

....will return only the date.

 

[StewartUK]

But DTOC(Datetime()) will return character (or string) data type, not an actual date data type.

end_date = DATE() will make variable end_date a date type.


Hope that helps,

Stewart
PS If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Mike Lewis]

Kev100,

The function you need is TTOD().

But I'm curious to know what the "upgrade" was that caused the problem.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk