Hello everybody, I am not an expert and I encounter some difficulties with the "datetimeAdd" function.
I have created a customed column which contains an integer (a number of monthes). Let us call this column "My column".
I want to create another customed column which will contain the "current date" + the number of monthes of the previous customed column (ie "My column").
- I have tried this syntax : datetimeAdd(now, [My column],"month") and get an error.
- I have tried a simplified syntax : datetimeAdd(now, 1,"month"). This works fine (but is of course of no use for me, I don't need Metabase to know which day is tomorrow
)
My question is the following :
Is it possible to create a column containing a date which would be : "the current date" + "A value in monthes contained in another column"
Thank you for your answer