4 Replies Latest reply: Jul 20, 2012 10:47 AM by Stefan Wühl RSS

    Today and  next working day

      Hi Guys

       

      Im creating a stacked bar chart and I wish for my demension to be today and tomorrow ( as in the next working day)

      I did try and load it as a field in my script - but the weekday part doesnt work ( as its returning null() ) and the format is just the number value of today 41110

       

       

      if(Date = today() or Date = today(weekday(1)),Date,null()) as Spotdate

       

      Can anyone please help?

       

      Thanks

       

      A