Today and next working day

[#1]

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

[swuehl · Accepted solution]

If (Date = today() or Date = LastWorkDate(today(),2), Date, NULL() ) as SpotDate

[#3]

Swuehl

You've helped me out loads , can you advise how to format as DD/MM/YYYY

Thanks yet again

A

[#4]

Ignore me

date(SpotDate)

Thanks

[swuehl]

Date(YourDateField,'DD/MM/YYYY')

e.g.

If (Date = today() or Date = LastWorkDate(today(),2), Date(Date,'DD/MM/YYYY'), NULL() ) as SpotDate