AnsweredAssumed Answered

Third party timestamp reformat confusion

Question asked by garyjones on Jan 25, 2019
Latest reply on Jan 25, 2019 by beverly

Hi,

I'm struggling with the one thing that really confuses me - date format.

 

I am importing a third party timestamp into a text field, whose output is formatted as "2019-01-13 10:07:59".

 

I've split the time out as an auto-enter calculation into a separate time field, but for the life of me cannot do the same with a similar and amended auto-enter calc date field that also changes and creates the format as "dd/mm/yyyy".

 

Applying the below calculation to the text string, 2019-01-13 10:07:59, returns the result as "12/07/0018".

 

Date(
GetValue ( Substitute (Substitute ( MailparserParsingDateImport; " " ; ¶); "-"; ¶); 2 );
GetValue ( Substitute (Substitute ( MailparserParsingDateImport; " " ; ¶); "-"; ¶); 1 );
GetValue ( Substitute (Substitute ( MailparserParsingDateImport; " " ; ¶); "-"; ¶); 3 ))

 

Again. I'm sure this is simple but am tying myself up in knots.

 

All help appreciated greatly.

 

Thanks

 

Gary

Outcomes