Hi,
I have two fields in my database TRAN_DATE and TIME
My TRAN_DATE is in the following format 20091215 (Text). I would like to format it in the following 12/15/2009?
And my TIME is the following 133502 (Text). I would like to format it in the following 13:35:02 HH:MM:SS
Any help would be appreciated.
Thanks
I have two fields in my database TRAN_DATE and TIME
My TRAN_DATE is in the following format 20091215 (Text). I would like to format it in the following 12/15/2009?
And my TIME is the following 133502 (Text). I would like to format it in the following 13:35:02 HH:MM:SS
Any help would be appreciated.
Thanks