Handling Dates

[Aspiring_Developer]

Hi ,

Currently i have below data set:

=============================================

this "Month " in the above table is created from the below script:-

Table_Budget:

Load Budget,

'Budget' a s flag

From .....

join

load * inline[

Month

Jan,

Feb,

Mar,

Apr,

May,

...

Dec

];

Final

Load *,

Num(Budget)/12 as New_budget

Resident Table_Budget;

Drop table Table_budget

Store * into Budget.qvd

===============================================================

Data:

Load

Object_no,

Flag,    //Flag for Actual

Date 

From ...[Actual.qvd](qvd);

Concatenate

Load 

Object_no,

Flag, //For Budget

"Month"

From ..[Budget.qvd](qvd);

======================================================

I have linked my "Master Calendar" with the "Date" feild.

However i am not able to understand , how should i link my "Month" field from "Budget.Qvd" to Master calendar as i want to display the months in fiscal year pattern and i have created inline starting from Jan to Dec.

Please help !

[marcus_sommer]

Just use a real date instead of a month. Means instead of using: Jan, Feb, ... you takes 01.01.2020, 01.02.2020, ...

- Marcus

[vidyut · Accepted solution]

Change the inline load of the month with something like this:

Load MakeDate(2020,RecNo(),1) as Month

Autogenerate 12;

And while concatenating, use the Month as Date in the fact, It should link to the Calendar then