Compare two Times for greater than/less than logic

[RohitAakula]

Hi,

I'm trying to compare two timestamps and decide whether provided time is before "05:00:00" or not but was not successful, please help me in this case. Thanks in advance!

[mbarone]

I always like to keep the Date Time Functions page bookmarked, as you'll refer to it a lot.  Check out the DateTime functions - there are a few that will help.  But a fairly straight forward formula should do the trick.

[Christina_H · Accepted solution]

Is this what you're trying to do?

[Jonathan-Sherman · Accepted solution]

Hi @RohitAakula,

You could achieve this with a formula to parse your time into a date to compare, i've assumed your time is not stored as a time data type just to be sure!

DateTimeParse(ToString('2000-01-01 ' +[Time]),'%Y-%m-%d %H:%M:%S') <= '2000-01-01 05:00:00'

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan

[Jonathan-Sherman]

And i'd agree with @mbarone, that DateTimeFunctions is probably my most referred to Alteryx help page!