I am not sure why my formula is working - it might be becuase my date format is wronf in my .xlsx source
This is the date format in yellow that is fed into Tableau:
This is my tableau formula that is returning 0:
I am wondering how I can get this fixed. Thnkas!
Replace DATE(13/07/2017) with DATE("7/13/2017"). It is being provided the month as 13 which makes it invalid.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...