Please Explain How To Convert The Date Format To The General Format In Alteryx?

I am trying to change the format of date in my files. someone, please explain how do I do it? I a specifically looking for Date-INT(Date). Thanks in advance

Alteryx

Date

Int

1 answer

Answers

Aryan Sharma

Posted on 20th May 2024

This formula can be used to extract the date: DateTimeAdd("1900-01-01",[Field Name],"days"). Note that we should subtract 2 from the general formula before processing because excel considers 1900 as a leap year.