System Calender

[#1]

Client need system calendar instead of master calendar what does it mean

[vardhancse]

Hi,

Might be the normal calendar what they follow instead of company calendar

[#3]

what is normal calender

[vardhancse]

In general will have 2 calendars.

1.Normal calendar

     a. april to march    

2. fiscal calendar

     a.it depends on the country where the company is being operated.

like fiscal year may start from Jan to december

[#5]

but as per my client this is not depend on any of the transaction table. it work as per system date

[svenkita]

The following script will give you a auto generated calendar based on min and max date, the max date is calculated as current date + 60

LET vDateMin   = Num(MakeDate(2012,1,1));

LET vDateMax   = Floor(MonthEnd(Today()+60));

LET vDateToday = Num(Today());

TempCalendar:

LOAD  $(vDateMin) + RowNo() - 1      AS DateNumber,

      Date($(vDateMin) + RowNo() - 1) AS TempDate

      AUTOGENERATE 1

WHILE $(vDateMin)+IterNo()-1<= $(vDateMax);

Star_Calendar:

Load

     TempDate                                               As Star_Date,

     Week(TempDate)                                         As Star_Cal_Week,

     Day(TempDate)                                          As Star_Cal_Day,

     Month(TempDate)                                        As Star_Cal_Month,

     Num(Month(TempDate))                                   As Star_Cal_MonthNum,

     Year(Date(TempDate,'DD/MM/YYYY'))                      As Star_Cal_Year,

     Num(Num(Year(TempDate))& Num(Month(TempDate),'00'))    AS Star_Cal_YearMonth,

     Month(TempDate) &'-'&Year(Date(TempDate,'DD/MM/YYYY')) AS Star_Cal_YearMonthDesc,

     Weekday(TempDate)                                      As Star_Cal_WeekDay,

     'Q'&Ceil(Num(Month(TempDate))/3)                       As Star_Cal_Quarter,

     Ceil(Num(Month(TempDate))/3)                           As Star_Cal_QuarterNum

Resident TempCalendar

Order By TempDate ASC;

Drop Table TempCalendar;

LET vDateMin   = "";

LET vDateMax   = "";

LET vDateToday = "";

[vardhancse]

Then not required any calendar, what ever dashboards/reports will be based on system date only.

[#8]

Actually two different table sales order and purchase order table , but date entry is different in both the table, client want that calendar will be linked to both the table and capture all data not on basis of any of the date either sales or purchase table

[Siva_Sankar]

Shweta Singh,

You have to use Canonical date for this. Look here Canonical Date and find the attached example also for

[#10]

I have  data model with sales order ,purchase order and purchase receipt table, I have to show PO , purchase receipt in one table,

CRD is customer required date

I used your logic it won't work