See Below Script and Attached File :
!
LET vDateMin = Num(MakeDate(2011,2,28));
LET vDateMax = Floor(MakeDate(2011,6,15));
LET vDateToday = Num(Today());
MATCON:
LOAD
[Doc. Date],
Date(Date#([Doc. Date],'DD.MM.YYYY'),'DD/MM/YYYY') as DOC_DATE
FROM
(ooxml, embedded labels, table is matcon);
STORE MATCON into D:\Nagarjun\Test\QVD\MATCONFINALCIALCALENDER.qvd(QVD);
DROP Table MATCON ;
New:
LOAD
DOC_DATE,
Day(DOC_DATE) AS CalendarDayOfMonth,
WeekDay(DOC_DATE) AS CalendarDayName,
Month(DOC_DATE) AS CalendarMonthName,
'Q' & Ceil(Month(DOC_DATE)/3) AS CalendarQuarter,
'Q' & ceil(month(DOC_DATE)/3) as New_Qutr,
YearName(DOC_DATE,0,2) as New_Financial_Year,
'FY' & Right( Year(DOC_DATE),2) as YearQtrfy,
YearName(DOC_DATE,0,2)as FiscalYear
FROM
(qvd);
