pablog - profile

pablog · Dec 13, 2023

Hi,I have a database with special dates of each month (Christmas, Halloween, etc). I'm using the DATEADD formula to add 1 year to a date field.For example, for Christmas I have the date 24/12/2023 and I expect the DATEADD formula to result in 24/12/2...

pablog · Dec 13, 2023

Yes! That's it!Thanks a LOT @BillH

pablog · Dec 13, 2023

Hi @BillH ,Thanks for your help. You are right, I should have shared my formula.Is exactly what you suggest (DATEADD({Fecha},1,'year')) and gives 23/12/2024 as a result.If I test DATEADD({Fecha},365,'days') the result is 22/12/2024 Any advice?Thanks...

User Statistics

User Activity

Dateadd Formula Wrong Result

Re: Dateadd Formula Wrong Result

Re: Dateadd Formula Wrong Result