Skip to main content

I want to loop through this format of a string and only execute a function if system date is more than this column, how can i compare the string to a system date. I have tried using datetime assign but the format is not getting accepted. The format I enter in custom format is MMM dd, yyyy HH:mm but its not getting converted to string for me to compare and execute next function. Please help

Timestamp
Jan 5, 2024 09:03
Jan 5, 2024 08:22
Jan 5, 2024 08:20
Jan 5, 2024 08:18
Jan 5, 2024 08:09
Jan 5, 2024 07:46
Jan 5, 2024 07:46
Jan 5, 2024 09:39

Hi @s 9425 ,

 

I hope this is the same issue as mentioned in your other Post.

 

Excel Datetime function

 

Reply