logo-MindMajix
A
Anthony A

Posted on 23rd June 2024|57 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

1 answers
Answers
P
Aryan Sharma

Posted on 23rd June 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.

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
Name
Course *
Email *
Phone Number