Aug 20, 2008 #1 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
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
Aug 20, 2008 #2 JBinQLD Programmer Aug 2, 2008 452 AU G'day mate, This produces 24 Dec 2008 for me: =CDate(Format(20081224,"####/##/##")) Have a great day, JB Upvote 0 Downvote
G'day mate, This produces 24 Dec 2008 for me: =CDate(Format(20081224,"####/##/##")) Have a great day, JB
Aug 20, 2008 #3 JBinQLD Programmer Aug 2, 2008 452 AU 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 Upvote 0 Downvote
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