Date formula Error
Hello - I am trying to reformat a date by using the date formula. I have the day pulled out in a Number column, I have the month pulled out in a Number column, and I have a year pulled out in a number column but it keeps giving me invalid data type
Answers
-
In your [Date Use] column (Text/Number format) , you could try:
=JOIN(YEAR(DATE@row) + "-" + MONTH(DATE@row) + "-" + DAY(DATE@row))
(where "DATE" is the column you're looking at, e.g. [construction ntp_Actual]
Another option might be to look at the formatting options for the actual date column and choosing your desired display format. -
Hi, @SarahConde -
If I understand what you're looking to do, I'd suggest trying something like this:
=DATE(VALUE(year@row), VALUE(month@row), VALUE(day@row))
That will help you pull those year, month, & day number values into a date format. (I made an assumption that your "Date Use" column was a date column.
Good luck!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!