Remote Posted October 15, 2004 Share Posted October 15, 2004 I am trying to find the easist way to return the current date in the format of MM/DD/YYYY. The problem is that Now() returns the time. This is what I currently have, im looking for a better/easier way. dtTodaysDate = Now strDateSent = Format(dtTodaysDate, "MM/DD/YYYY") dtTodaysDate = DateValue(strDateSent) dtDateSent = dtTodaysDate Link to comment Share on other sites More sharing options...
0 James Rose Posted October 15, 2004 Share Posted October 15, 2004 dim sDate as string sDate = format$(Date, "MM/DD/YYYY") --- Easy enough? Link to comment Share on other sites More sharing options...
0 Remote Posted October 15, 2004 Author Share Posted October 15, 2004 dim sDate as stringsDate = format$(Date, "MM/DD/YYYY") --- Easy enough? 584740601[/snapback] if it works...you bet! Thanks Link to comment Share on other sites More sharing options...
0 Civilian Posted October 16, 2004 Share Posted October 16, 2004 dtTodaysDate = Date$ strDateSent = Format(dtTodaysDate, "MM/DD/YYYY") dtTodaysDate = DateValue(strDateSent) dtDateSent = dtTodaysDate Link to comment Share on other sites More sharing options...
Question
Remote
I am trying to find the easist way to return the current date in the format of MM/DD/YYYY.
The problem is that Now() returns the time. This is what I currently have, im looking for a better/easier way.
Link to comment
Share on other sites
3 answers to this question
Recommended Posts