Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If (Date = today() or Date = LastWorkDate(today(),2), Date, NULL() ) as SpotDate
If (Date = today() or Date = LastWorkDate(today(),2), Date, NULL() ) as SpotDate
Swuehl
You've helped me out loads , can you advise how to format as DD/MM/YYYY
Thanks yet again
A
Ignore me
date(SpotDate)
Thanks
Date(YourDateField,'DD/MM/YYYY')
e.g.
If (Date = today() or Date = LastWorkDate(today(),2), Date(Date,'DD/MM/YYYY'), NULL() ) as SpotDate