having problem with end date

Report Inappropriate Content · ‎2013-03-25

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 · ‎2013-03-25

Hi,

Just try this.

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

This will add one day into the WeekendDate.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!