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,
Hi @Pascal_R ,
to calculate the difference between dates you have to convert the date to a Date (or Datetime) datatype using DateTimeParse([DateField], '%d.%m.%Y') if your date has the format dd.mm.yyyy. The function DateTimeDiff([LastDate], [FirstDate], 'days') will return the difference in days.
Let me know if it works for you.
Best,
Roland
Hi RolandSchubert,
I converted now the actual date and the SLED/BBD to Datetime but as you can see on the screenshot there is something not working with "days" on the difference formula... do you see what Needs to be changed?
Hi @Pascal_R
Your actual date is not in a datetime format alteryx need its to be in YYYY-MM-DD HH:MM:SS if you use datetimenow() those formulas should work so long as SLED/BBD is in the correct format. Datetimediff needs the dates to be in the correct format in alteyrx to work I have mocked up a workflow to showcase this.
