Hi all,
Is there a frormula or a way to have the date format like 18.05.2020 instead of 2020-05-18?
Thank you for your help.
Pascal
Hi @Pascal_R I amended your workflow. Let me know what you think?
Hi @Pascal_R I mocked up a workflow you can use the dateformat function to format a date to whatever you need it to be however it will have to be a string field in alteryx as it only recognises dates in the format YYYY-MM-DD as a true date format.
Thank you JosephSerpis
For calculate the difference between Dates I have to use the format YYYY-MM-DD as string field?
I like to calculate the "expire date - actual date" = difference in days...
Regards,
