Dear Alteryx community,
Any chance to take your brain:
Task
I am consolidating YTD sales data from January to September. I have launched a new product from March 24 onwards so I'd like to create a simple formula to sort out those sales records after product launch.
My simple formula is: iif([Order Date (Header)]>"24-03-2021","yes","no"). However, this seems to be not working. I make sure that the original data type of the sales order date is a date not a string. Wonder what mistake I have made...thanks a bunch!
cheers,
Miki
Solved! Go to Solution.
Hi @Miki2021,
If you are comparing dates, make sure to use the ISO 8601 date format ("YYYY-MM-DD"). Moreover, I would recommend to use the DateTimeDiff() function to identify the time difference.
Please find attached a working example.
Try to change the formula like this :
iif ([Order Date]>"2021-03-24","yes","No")
Best regards,
Alteryx default date pattern is "yyyy-mm-dd".
Try "2021-03-24".
Regards,
Shreyansh