You are viewing limited content. For full access, please sign in.

Question

Question

DATEDIF function in workflow doesn't appear to be a date difference, just a difference

asked on November 29, 2018 Show version history

DATEDIF says it returns the difference between x1(date) and x2(date), but it is just acting like a subtraction function.

For example this test returns 1 year, which is not the difference between the two dates, it is just the basic math function 2001-2000. I could do that! I need the difference between two dates. In this case it should be zero.

DATEDIF( %(RetrieveFieldValues_Date of Birth), %(Date), "Y")

 

0 0

Replies

replied on December 4, 2018

This only seems to be an issue when the 2 dates are in different years. Bug reference #144934. We'll try to look into it for 10.4.

0 0
replied on December 4, 2018

Ok thanks! I will replace it with a C# function in the meantime.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.