Time

NavinReddy — Tue, 06 Aug 2013 08:46:29 GMT

Hi All,

Some one help me

current week Sunday- saturday using system time

thanks in advance,

rohith

Re: Time

NavinReddy — Tue, 06 Aug 2013 09:48:19 GMT

Hi vishwa,

These two expression not working for me

thanks,

rohith

hic — Tue, 06 Aug 2013 11:20:13 GMT

If you want to define week numbers and week days using Sunday as the first day of the week, you have to write your own expressions.

One way to do it is the following

Load *,

Dual(WeekDay(Date),Mod(WeekDay(Date-$(vFirstWeekdayOfWeek)),7)) as WeekDay,

Ceil((Date-FirstDateOfWeekOne+1)/7) as WeekNumber,

Date(WeekStart(Date-$(vFirstWeekdayOfWeek))+$(vFirstWeekdayOfWeek)) as WeekStart;

Load *,

Date(

WeekStart(YearStart(Date)+$(vMinDaysInWeek)-$(vFirstWeekdayOfWeek)-1)

+$(vFirstWeekdayOfWeek)) as FirstDateOfWeekOne,

HIC