topic Re: How to remove AM or PM from time in App Development

How to remove AM or PM from time

Anonymous — Wed, 02 Aug 2017 11:17:06 GMT

How Can I remove AM or PM from Time ?

ankur_abhishek — Wed, 02 Aug 2017 11:19:41 GMT

Hi Momin

Use replace function

Replace( Replace(Field name, 'AM', ''),'PM','') or you can use Left function to extract some character of values.

Regards

Ankur

Anonymous — Wed, 02 Aug 2017 11:22:12 GMT

Brother I want to Remove not replace

ankur_abhishek — Wed, 02 Aug 2017 11:28:33 GMT

Hi Momim

This will remove your AM & PM from time field .

Trim(Replace( Replace(Field name, 'AM', ''),'PM',''))

tomasz_tru — Wed, 02 Aug 2017 11:29:25 GMT

Is it a string od timestamp? Try Purgechar(Field, 'PMA')

Tomasz

kusumanchir — Wed, 02 Aug 2017 11:39:57 GMT

Hi Momin,

Please try this,

Timestamp(<The timestamp field>,'DD/MM/YYYY hh:mm:ss')

Anonymous — Wed, 02 Aug 2017 12:13:49 GMT

Thanks

Anonymous — Mon, 07 Aug 2017 05:59:34 GMT

load *,Timestamp#(PurgeChar(StartDate,'AMP'),'DD/MM/YYYY HH:MM') as NewStartDate,

Timestamp#(PurgeChar(EndDate,'AMP'),'DD/MM/YYYY HH:MM') as NewEndDate

Resident Temp;

DROP Table Temp;