Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formating now()

Status
Not open for further replies.

hwkranger

MIS
Nov 6, 2002
717
US
if i have a a variable, that is a date, and it's called say:
workdate and I want to have it today's date I use the now() function, but I'm not sure how to clip off the time. I only want the dd-mm-yy. but i'm getting time with it also.

I know that if i use a string I can use left([variable],length) but.. i was hoping there's another way.

tty Cruz'n and Booz'n always.
This post shows what little I do at work.
 
dude that posted the format msg on time answered my question. thx Cruz'n and Booz'n always.
This post shows what little I do at work.
 
another thing to look at...
try using
Date()
:) Enjoy.
--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top