Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 07, 2024 09:11 AM
I'm having trouble with using the DATEADD function (and yes totally new at this). I'm trying to add 3 months to a date in another column. I've technically gotten the formula to work but it's not quite getting the desired date. So for example if my date is 4/1/2024 and the formula is adding 3 months it's calculating 6/30/2024. I need it to actually calculate 7/1/2024. I've tried to add a day to the formula but keep getting an error. Any help would be great. Thanks in advance.
Solved! Go to Solution.
Feb 07, 2024 08:13 PM
Could you provide a screenshot of your date and formula field with the timezones displayed?
This is my formula:
DATEADD(
Date,
3,
'months'
)
And this is my result:
And so kuovonne's probably right about it being a timezone issue since our formulas are the same but our outputs are different
Feb 07, 2024 11:24 AM
When a date related field is off by one day, it is often a timezone issue.
Check the timezone settings in the formatting options for your formula result.
Feb 07, 2024 12:07 PM
Time zones are the same. I think what I need is to add 1 day. I think the formula is correct: DATEADD ({Annual Due}, 3, 'months'). So it's adding 3 months, but instead of going to the exact date three months later it's going to the day before, e.g., 4/1/2024 and then the formula column is 6/30/2024. I've tried to do this same formula this way to add the extra day but it doesn't quite work: DATEADD ({Annual Due}, 3, 'months', 1, 'day'). I know I'm missing something here to add the extra day.
Feb 07, 2024 08:13 PM
Could you provide a screenshot of your date and formula field with the timezones displayed?
This is my formula:
DATEADD(
Date,
3,
'months'
)
And this is my result:
And so kuovonne's probably right about it being a timezone issue since our formulas are the same but our outputs are different
Feb 08, 2024 04:29 AM
You were right. Now just getting it the right time zone haha. Thank you very much. I thought I had done this but apparently not.