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
Solved! Go to Solution.
Got it, i had to convert the datatype to date/time and it worked.