Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Below is my data
Submited By |
1158631: Degalesan, Raghunathan - 02/03/2015 10:48:28 PM# |
1158631: Degalesan, Raghunathan - 02/03/2015 10:56:38 PM# |
1158631: Degalesan, Raghunathan - 02/03/2015 11:21:16 PM# |
1163317: palanikumar raman - 05/03/2015 08:47:23 PM# |
1166466: Srinivasan Gayathri - 03/03/2015 07:43:49 PM# |
1166466: Srinivasan Gayathri - 04/03/2015 08:46:45 PM# |
1166466: Srinivasan Gayathri - 08/03/2015 05:26:02 PM# |
Sample Output in the below format
41907.57775 |
41907.57775 |
The date , time given in Submitted Column should be shown like above.
=Date('41907.57775','DD/MM/YYYY hh:mm:ss')
Hi
Try like this
=Timestamp(DateField ,'DD/MM/YYYY hh:mm:ss TT')
Hi,
use subfield()
try like
Timestamp#(purgechar(subfield(fieldName,'-',2),'#'),'DD/MM/YYYY hh:mm:ss tt')
or
Timestamp(Timestamp#(purgechar(subfield(fieldName,'-',2),'#'),'DD/MM/YYYY hh:mm:ss tt'))
or
Date#(purgechar(subfield(fieldName,'-',2),'#'),'DD/MM/YYYY hh:mm:ss tt')
or
Date(Date#(purgechar(subfield(fieldName,'-',2),'#'),'DD/MM/YYYY hh:mm:ss tt'))
Regards
or date('41907.57775','DD-MMM-YYYY')
Hi, try this:
num(Timestamp(date#(SubField(PurgeChar([Submited By],'#'),'- ',2),'DD/MM/YYYY hh:mm:ss TT')))
=Date(41907.57775,'dd-MM-yy') --> 25-09-14
=Date(41907.57775) --> 9/25/2014