Hi

I have a date (in HYYMDS format) that I pull from the database

Input_field(in HYYMDS format)
2011/01/01 08:15:00
2011/02/10 15:00:00
2011/01/01 21:25:00
2011/01/01 01:50:00


i have requirements like this
Out_field
08:15 AM
03:00 PM
09:25 PM
01:50 AM


can any one guide me how to do this plz...

This message has been edited. Last edited by: Kerry,

Hi Deepu,

use the search!!!
Here you are:
http://forums.informationbuild...851086012#3851086012

Regards

Christian

Deepu,

The HCNVRT function will get you what you want:

  
HCNVRT( datetimestamp , '(HHIA)',10,'A10')