Skip to Content
0
Former Member
Jun 09, 2009 at 12:55 AM

System Date calculation

270 Views

Hi Gurus

I have to update the data from one DSO to another DSO using transformation. We generally load the data on Monday but we can do so even sometime in middle of the week. The logic which we are looking for is

Take the system date and calculate the From Date and To Date

Logic

From Date:- Monday of the previous week

To Date:- Sunday of the previous week

Eg. say today is 6/8/09

so the From data will be 6/1/09

and To Date will be 6/7/09

Can you please give me the logic for this.

Really Appreciated

Prat