Week Question.....???

[aveeeeeee7en]

Hi All

See my Requirement below:

See the Attached qvw.

Regards

Av7eN

[Gysbert_Wassenaar]

ABC:
LOAD *, AutoNumber(New_Week, New_MonthName) as New_MonthWeek;
LOAD *,
    'Week'&Ceil(Day(New_Date)/7) as  MonthlyWeek,
    Week(New_Date) AS New_Week,
    WeekDay(New_Date) AS New_WeekDay,
    WeekEnd(New_Date) AS New_WeekEnd,
    WeekName(New_Date) AS New_WeekName,   
    MonthName(New_Date) AS New_MonthName,
    Day(New_Date) AS New_Day;
LOAD
    Date(MakeDate(2015,1,1)+RecNo()-1,'DD/MM/YYYY') AS New_Date
AutoGenerate(365);

See attached example.

[aveeeeeee7en]

Thank You Sir.

Regards

Av7eN

[aveeeeeee7en]

Dear Sir

The below difference is coming in February & March Month when I am Selecting Week 1.

Feb & March both have first day Sunday.

Regards

Av7eN

[Gysbert_Wassenaar]

Works fine for me in the example I posted.

[aveeeeeee7en]

Dear Sir

Also, Nov 2014 Data is coming Wrong.

See Week1 Data for Nov 2014:

Sir,

See the Attached qvw.

Regards

Av7eN

[Gysbert_Wassenaar]

Change the BBB load to:

BBB:

LOAD DISTINCT *,

    Week(UPDATE_DATE) AS New_Week, 

    MonthName(UPDATE_DATE) AS New_MonthName                  

Resident ABC

ORDER BY UPDATE_DATE;

[aveeeeeee7en]

Not Working.

I am getting strange results now.

Causing Problem for March 2015.

[Gysbert_Wassenaar]

Post the source file.

[anbu1984]

Check my solution here Week Logic Requirement..............???