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...