Hi, I have my data published in Tableau Server. I have a field that is :
If [date1]>(if DATENAME('weekday',TODAY())="Monday" then [date2] ELSE [date3] END) and [date1]<[date4] then 1 END .
All dates are in string format and it works. It sums the users that made a purchase between those dates
I now have to change 'date2' and 'date3' because the conditions have changed. I created new fields (which are not published to the server) and the formula doesn't work
Can you be more specific on what you mean by "doesn't work?" Are you getting an error? Can you attach a packaged workbook with samples of all of the date fields (dates are no exactly confidential - everybody has them ). You can strip out any confidential fields, or see Anonymize your Tableau Package Data for Sharing |Tableau Support Community, if needed.