I have a date field in MDYY format.I want to convert it to HYYMDs format.How can I do that?
Is there a function.

Can somebody help me.

Thanks

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

Function HDTTM will convert SmartDates to date-time values.

Swetha, please familiarise yourself with the Date-Time functions, they are all in the documentation.

Date Time Functions

Thanks a lot for your Ideas.