community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

Nested IF Date format problem.

Highlighted

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?

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