Convert String to Date and Perform Calculation

[jagjit_singh]

Hi All,

I have tried all the string to date tools in Alteryx which formats the date to dd/mm/yyyy but when i perform a calculation like  

DateTimeAdd([Entry Date],-1,"days") = [Exit Date] it does not work. Any ideas?

TENANT_NUMB	Entry Date	Old Property	New Property	Exit Date
10581	2013/12/02	1069	1080	2013/12/01
10581	2014/02/26	1069	3869	2013/12/01
10581	2013/12/02	1080	1080	2014/02/25
10581	2014/02/26	1080	3869	2014/02/25

Thanks

Jag

[jagjit_singh · Accepted solution]

Got it, i had to convert the datatype to date/time and it worked.