I tried to replicate how you described your problem.
For me, the error says:
Dateadd will make a datetime out of your date, wrapping the complete dateadd part in date() can fix that.
You could alternatively just use "[Dates] + [Days]" as your calculation which will give the same results.
BUT: since some of your dealers have NULL as Days you definitely need to wrap Days in a Ifnull() function.
This will use Days if it is not null and 0 otherwise (ifnull(Days, 0))
That is correct, I can successfully create the formula I need using the "ifnull" and "dateadd" function, and am able to successfully adjust my dates based on the dealer I am shipping to. However, to then use that "Adjusted Date" field in order to bring in my fiscal dates is where I continue to run into issues.
Dates Question.twb 15.7 KB
Apologies for the late reply.
I think I should have made it clearer in my other post - when you use the dateadd function Tableau will make a date+time format.
Your dates in the table are of the format date though.
Hence there is a mismatch of formats and tableau is unable to join on these fields. The same happens when you try to join a string with a number.
If you just put a date() around the formula you already have in your join calculation it will join correctly
Thank you so much! Sorry I'm a little slow! Excellent,