Skip to main content
Answer

Excel Datetime function - Assign function not working correcting

  • January 15, 2024
  • 1 reply
  • 104 views

Forum|alt.badge.img+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

Best answer by Padmakumar

Hi @s 9425 ,

 

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

 

Excel Datetime function

 

1 reply

Padmakumar
Premier Pathfinder | Tier 7
Forum|alt.badge.img+15
  • Premier Pathfinder | Tier 7
  • Answer
  • January 16, 2024

Hi @s 9425 ,

 

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

 

Excel Datetime function