March 11, 2015 at 6:01 am
Hi guys,
I am now creating a filter to say the following
if(weekdayname(weekday(today())) AND booking start date>today(),dateadd(Day,3,today()), bookingstartdate>today() AND dateadd(Day,1,today())
However I get the message returned that weekday is not a valid identifier.
Can anyone suggest a solution to this?
March 11, 2015 at 7:21 am
That does not make sense, what is the filter supposed to do?
Far away is close at hand in the images of elsewhere.
Anon.
March 11, 2015 at 7:42 am
Thanks for replying, basically if today is a Friday then show the data for Saturday, Sunday, Monday, if it's not a Friday show the data for the following day based on the booking start date.
March 11, 2015 at 7:54 am
Add a filter, select booking date from the dataset, select >= and set the expression for the value to
DateAdd(DateInterval.Day,1,Today)
Add a seconf filter, select booking date from the dataset, select <= and set the expression for the value to
IIF(Weekday(Today,0)=5,DATEADD(DateInterval.Day,3,Today),DATEADD(DateInterval.Day,1,Today))
This assumes that booking date is a date datatype (ie no time) otherwise use 4 and 2 in the second filter and use < as the comparison
*Edited* to fix 2nd expression
Far away is close at hand in the images of elsewhere.
Anon.
March 11, 2015 at 8:31 am
Thanks for this David,
Much appreciated
I will learn from this so that in future the expressions make more sense 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply