Solved: Why is the date "12/30/1899 12:30:00AM"?

Tiger1 · 03-05-2020 09:08 AM

I wrote an expression trying to fire a workflow rule once a duration is hit. But i noticed the date and time are WAAAY off:

Steve

Your literal values, 00:30:00, are interpreted as a DateTime without a date. A Datetime without a date is given a default date of Dec 30, 1899.

What column type is Hours to Arrival? If Duration, your literal values should also be Duration values. A literal Duration value appears to be a Time value, but has at least three digits in the hours position. For instance: 000:30:00.

View solution in original post

Steve

Your literal values, 00:30:00, are interpreted as a DateTime without a date. A Datetime without a date is given a default date of Dec 30, 1899.

What column type is Hours to Arrival? If Duration, your literal values should also be Duration values. A literal Duration value appears to be a Time value, but has at least three digits in the hours position. For instance: 000:30:00.

Tiger1

Ok. You were right. It is of Type - Duration. I made the adjustment. Looks fine now. Thanks again.