Date Expression issue

[Nagaraj6]

Hello All,

I need a help

Above is qlikview output: I Need expression In a month  of 1st date to yesterday Booking counts is the Backward Booking,

today to end of month is the Forward booking. I am using only Tour_Start_Date with  that I have calulate this.

Example Tour_Star_date :

I need expression?

output this form:

Regards

Nag..

[Chanty4u · Accepted solution]

Try this 

Backward Booking Count:

Count({<Tour_Start_Date = {"<=$(=Date(AddMonths(MonthStart(Today()), -1), 'YYYY-MM-DD'))"}>} Tour_Start_Date)

Forward booking count

Count({<Tour_Start_Date = {">$(=Today())"}>} Tour_Start_Date)

[Nagaraj6]

@Chanty4u  Thank you!!

I got this below 

is this Forword booking  end of the month only or next month also will included??

and How to sum of Both expressions?