Forum Discussion
ADumith
May 03, 2023Iron Contributor
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,
Change L218 to LEFT(L218,10)+RIGHT(L218,8)
1 Reply
Change L218 to LEFT(L218,10)+RIGHT(L218,8)