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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Format 20081024 convert to 24/10/2008

Status
Not open for further replies.

barra47

Programmer
Dec 25, 2002
86
AU
I have connected to a database tables using ODBC but dates are stored as a number eg 20081024

I need to ceiw this in forms or reports as 24/10/2008
Can anyone help me with a fis on this

Thanks in advance
 
G'day mate,

This produces 24 Dec 2008 for me:

=CDate(Format(20081224,"####/##/##"))


Have a great day, JB
 
Apologies if this posts more than once, keeps locking up on submit...

G'day mate,

This produces 24 Dec 2008 for me

=CDate(Format(20081224,"####/##/##"))

Have a great day, JB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top