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...
- May 03, 2023
Change L218 to LEFT(L218,10)+RIGHT(L218,8)
HansVogelaar
May 03, 2023MVP
Change L218 to LEFT(L218,10)+RIGHT(L218,8)