Skip to Content
0
May 01, 2020 at 01:56 AM

How to convert a number for example 43205 to a date in a calculation view

41 Views

In a calculation view we are building weighted average s for cutoff dates where we need to multiply dates with their quantities For example 01-01-1900 *20 units.....in this scenario we have desinged to get the number value of the dates like in Ms Excel....for the above date 01-01-1900 the value is '1' so the multiplication can happen...

Now it is '1'*20 =20 ....

Now 20 is the weighted date and it's date value is the final output for our scenario....which is 20-01-1900

I am stuck at finding a way now to read back/convert the value 20 to a date....in calculation view

Can anyone help us....