topic having problem with end date in QlikView

having problem with end date

Mon, 25 Mar 2013 13:22:13 GMT

hi i am having two table's

but in table A the weekend date is 1/09/2011

and in table B weekend date is 1/08/2011

is there any way where i can make 1/09/2011 to 1/09/2011

kaushiknsolanki — Mon, 25 Mar 2013 13:23:50 GMT

Hi,

Just try this.

Load date(WeekEndDate + 1) as WeekendDate from B.

This will add one day into the WeekendDate.

Regards,

Kaushik Solanki