The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hope someone can help me with this. I would like to calculate a date which is 3 months from a date in my table. I’ve seen someone give a solution to a similar problem but it returns a text value and I need it to be a date.
Any suggestions?
You are right - I was totally overthinking it - easy to do once you go down the rabbit hole :slightly_smiling_face: Thanks, this works perfectly!
My next challenge is to create a formula that returns a value based on this date…I am almost certain I...
Additional problem - I now want to work out how many days until the expiry date, but because the formula does not return a date format, I can’t use FROMNOW. I feel like DATETIME_PARSE might help but I can’t quite work out how to do it. Anyone have an...
Thanks! This works - the only thing is it returns it in the default Local/US format and I need it to be European. Do you happen to know if there a way to convert it (using another field if necessary?)
Edited to add: I have found out how to set the ti...