AlteryxPosted on 25th July 2024|57 views
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
Posted on 25th July 2024| views
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.