coverting from odbc date to string 1

[leadman]

Hi all,

I am saving a date/time object in my database using createODBCDateTime. When I retrieve the date I want to display it like this: Saturday June 1, 2002 2:25PM

How do get this from the ODBC date?

 

[Sarky78]

You need to use the DateFormat and TimeFormat functions.

So you code would look something like this:

#DateFormat(yourodbcDate, "dddd mmmm d yyyy&quot#
#TimeFormat(yourodbcDate, "h:mmtt&quot#

hope this helps !

 

[leadman]

thanks arperry