Handling Dates

Aspiring_Developer — Thu, 06 Feb 2020 10:52:15 GMT

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 !

Re: Handling Dates

marcus_sommer — Thu, 06 Feb 2020 11:27:46 GMT

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

- Marcus

Re: Handling Dates

vidyut — Thu, 06 Feb 2020 11:49:34 GMT

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

topic Re: Handling Dates in App Development

Handling Dates

Re: Handling Dates

Re: Handling Dates