What is the best way of comparing two dates in a workflow? I have the following use case:
I have two date/time variables, Ship1 and Ship2 and then I have another data/time variable that I will use to write to SQL. Call that SQLShipDate. My logic is as follows:
Set SQLShipDate = Ship1.
Set Ship2 from the list data. If the list data is blank, the value that gets placed in here is 1/1/0001 12:00:00AM
I have a RUN-IF action that says, If Ship2 does not equal 1/1/0001 then SET SQLShipDate = Ship2
So on my TESTS here is what I get:
Ship1 = 1/26/2017
Ship2 = blank (1/1/0001)
SQLShipDate is 1/26/2017 (what it should be)
Ship1 = 1/26/2017
Ship2 = 3/1/2017
SQLShipDate is 1/26/2017 (this has failed the test. It should be 3/1/2017)
As I run my workflows, the RUN-IF action never works. No matter what date Ship2 is, it never passes the RUN-IF comparison.
I can't figure out what else to do. Does anyone have any suggestions on how to do date comparisons or check a date variable for an empty value? I also tried creating an empty date variable and comparing but that didn't work either.