Strip SmallTime from Date - VbFormat?

J

jason

Could someone help me work out out a way to either convert a smalldatetime
value from my database(access) to a normal date with out the trailing time.

Is it simple matter of using FormatDate or does one need to do string
maniupulation?

Current
9/13/2003 11:36:00 AM

What I want:
9/13/2003

Thanks
Jason
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem formatting dates from CSV file 2
Issue with OLE DB Query - Date Search 0
Total Minutes Worked Within IVR Timing 1
Grouping/Deleting Dates/Times (HELP ANYONE!) 2
15 minute data to daily data 1
Start and End times - same date 8
Issue with OLE DB Query - Date Search 3
Date Comparison - An Easier Way? 6

Top