query to get weekending date(friday) using any day in a week
JV123Apr 18 2013 — edited Apr 18 2013Hi,
I need to get week ending date for the date within a week. ex: if gl_date =4/17/2013 then based on this date weekending date should generate and it should be friday of that week i.e 4/19/2013
how can I write query for that?
Appreciate you for your help.