This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...