6 Replies Latest reply on Nov 30, 2015 6:17 AM by Eddy Lindeboom

    Need help with Dateparse week function

    Eddy Lindeboom

      Hi guys,

       

      I often use the dateparse function for converting sloppy Google Analytics date formats into Tableau date formats. Months works fine, weeks don't. Does anyone have a solution?

       

      What works (month):

      201501

      201502

      etc...

       

      DATEPARSE("yyyyMM", [Date dimension])

       

      What doesn't work (week):

      201533

      201534

      201535

      etc....

       

      DATEPARSE("yyyyww", [Date dimension])

       

      It doesn't return the right weeks..