topic Re: Comparing current date to static date then adding X days in Alteryx Designer Desktop Discussions

Comparing current date to static date then adding X days

dareinnyc — Mon, 04 Nov 2019 17:17:30 GMT

Hi all,

I need help coming up with a formula to:

1. Pull today's date (date only)

2. Compare it to the target hire date.

3. If today's date is within 30 days of the target hire date (i.e. Today's date - target hire date < 30)

4. Then add 30 days to the estimated hire date (new column called new target hire date)

My current formula is (wrong):

IF DateTimeNow()-[Target Hire Date]<30
THEN DateTimeAdd([Target Hire Date],30,"days")
ELSE [Target Hire Date]
ENDIF

Re: Comparing current date to static date then adding X days

philipmannering — Mon, 04 Nov 2019 17:20:33 GMT

Hey @dareinnyc

if DateTimeDiff([DateTimeNow(), [Target Hire Date], 'days') < 30 then DateTimeAdd([Target Hire Date],30,"days") else [Target Hire Date] endif

Let me know if this works.

Re: Comparing current date to static date then adding X days

dareinnyc — Mon, 04 Nov 2019 17:33:00 GMT

Classification: Internal
Hi, this doesn't seem to work as it is still adding 30 days to all target hire dates after datetimenow. The logic should only add 30 days to the target hire date should the original target hire date be less than 30 days from datetimenow. Thanks

Re: Comparing current date to static date then adding X days

dareinnyc — Mon, 04 Nov 2019 18:28:50 GMT

Its ok, i switched the fields around and it works now.

IF DateTimeDiff([Target Hire Date],DateTimeNow(), 'days')<30
THEN DateTimeAdd([Target Hire Date],60,"days") ELSE [Target Hire Date]
ENDIF