Solved

Excel Datetime function - Assign function not working correcting

  • 15 January 2024
  • 1 reply
  • 42 views

Badge +5

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
icon

Best answer by Padmakumar 16 January 2024, 07:40

View original

1 reply

Userlevel 7
Badge +13

Hi @s 9425 ,

 

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

 

Excel Datetime function

 

Reply