Forum Discussion

ADumith's avatar
ADumith
Iron Contributor
May 03, 2023
Solved

Convert DateTimeStamp in a valid DateTime.

Hello guys,

 

I have this formula:

=IF(AND(E2<>"Solved",E2<>"Close"),NETWORKDAYS.INTL(L218,NOW(),1,9),FALSE)

This helps me to calculate the age of the records when the criteria are met.

 

For this I take into account the date of the record but I just realized that the date comes in this format 2023-01-01-01T18:05:27, so the question is, how can I extract the date and time from there, so that the data looks like this: 2023-01-01-01 18:05:27 and include it in my original formula

 

Thanks in advance,