Need to split date and time

[ar_nagarjuna2]

Hi All,

I need to split the date and time which is coming from  field A to target fields B ,C. format is mentioned below

source field A: YYYYMMDDhhmmssmmmuuun

Target B : YYYYMMDD

Target C: hhmmssmmmuuun

Can we do this using standard functions or required to write UDF?

Can any one help on to write UDF or Standard logic..

Thanks,

Nagarjuna AR

[former_member182412]

Hi AR,

You can use DateTrans function for this.

Regards,

Praveen.