Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Field with DATEADD function not matching value in other Date field

Topic Labels: Automations Formulas
Solved
Jump to Solution
1768 2
cancel
Showing results for 
Search instead for 
Did you mean: 
CharlieMullin
7 - App Architect
7 - App Architect

I have a Date field (Date Asset Added) whose value is entered manually formatted like this:

12/8/2023

Another field (Date RM) contains this formula:

 
DATEADD({Date Asset Added}, 0, 'day' which outputs this:
 
12/8/2023.  12:00am
 
I want to execute an automtion when these two values match, which they don't. So I tried using thiis:
 
DATETIME_FORMAT(DATEADD({Date Asset Added}, 0, ‘days’), ‘M/D/YYYY’)) which outputs this:
 
2023-12-08T00:00:00+00:00
 
 I think that DATETIME_FORMAT turns the date value into text. In any case, what formula can I use to get the value of the field Date RM to match the value in Date Asset Added?
 
1 Solution

Accepted Solutions

Hi Ella, thanks for that tip, which worked!

I got into trouble when I tried wrapping the DATEADD function inside a DATETIME_FORMAT function which changed the field type from Date to Text.

And all I had to do was turn off including time.

 

 

See Solution in Thread

2 Replies 2
Ella
7 - App Architect
7 - App Architect

Hi @CharlieMullin ,

Have you tried formatting the DateRM field to not include time?

Ella_0-1702586703779.png

Ella_1-1702586777237.png

 

 

Hi Ella, thanks for that tip, which worked!

I got into trouble when I tried wrapping the DATEADD function inside a DATETIME_FORMAT function which changed the field type from Date to Text.

And all I had to do was turn off including time.