Trying to Create a formula

[TP1]

Have two Effective Date's from two different systems both Joined by a Unique Identifier. When I enter the effective date in one system it jumps a day ahead for example - in the Request the effective date would be the 30/09/2018 so when I enter that into our system the effective date would show as the 01/10/2018. happens automatically in Background!

I'm looking to create an IF Statement to say that If Effective Date = Effective Date +1(From other System) Then 1 ELSE 0 ENDIF but I'm quite new so having difficulty creating the formula.

Thanks for help.

[danilang · Accepted solution]

Hi @TP1

The specific function you're looking for is DateTimeDiff.  this gives you the difference between 2 datetimes in the units you specify

After re-reading your post, I think I may have mixed up the 2 dates.  If that's the case then change the formula to 

iF datetimediff([EffDateOtherSystem],[EffDate],"days")=-1 then
	1
else
	0
endif

"=1" changed to ="-1", or change the order of the date fields in the formula.

Dan

[TP1]

Thanks a million for your help!