A
Anthony A

Posted on 27th February 2024|47 views

0
votes

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

Answers
P
Aryan Sharma

Posted on 27th February 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.

Write your answer

STILL GOT QUERIES?

Get a Live FREE Demo
  • Explore the trending and niche courses and learning maps
  • Learn about tuition fee, payment plans, and scholarships
  • Get access to webinars and self-paced learning videos