Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Nested IF Date format problem.

Highlighted
7 - Meteor

Hi All,

 

I have a problem in handling Nested If statement and I don't understand why is not working.

I am afraid that problem occurs because of date format.

Could you please help me with this?

Highlighted
Alteryx
Alteryx

Hi @Aleksander_Gorski,

 

I have fixed your IF statement and the workflow is attached. You have to be careful when dealing with dates in Alteryx as they have to be in a certain format and you must use the functions available in the formula tool to manipulate the data in the way you need. A few key things to note:

  • DateTimeParse(<date>,<format>) - you need to use this to inform Alteryx that the string value "01-01-2019" needs to be treated as a date and what the particular date format is. Check here for Date Format syntax.
  • DateTimeDiff(dt1,dt2,'years') - to find the difference between dates.
  • In an IF statement, you shouldn't refer to the field - it should read 'THEN 5' not 'THEN [FieldName] = 5'

 

If [End date] < DateTimeParse("01-01-2019",'%d-%m-%Y')
Then 5
        
ElseIf [End date] = "" 
Then
        5
    
ElseIf [End date] > DateTimeParse("01-01-2119",'%d-%m-%Y')
Then
         5
        
Else
        
	If [Start Date] > DateTimeParse("01-01-2019",'%d-%m-%Y') 
	Then
        
	DateTimeDiff([End date],[Start Date],'years')
        
	Else
        
	DateTimeDiff([End date], DateTimeParse("01-01-2019",'%d-%m-%Y'),'years')

	EndIf

EndIf

 

Hope this helps. Please refer to to the help documentation - https://help.alteryx.com/current/Reference/Functions.htm?Highlight=datetimeformat - if you need some more information on some of these DateTime functions. Let us know if you have any more questions or need any more help.

 

Best,

 

Luke 

 

Labels