How to make date from date field of attached sheet ?

[shekhar_analyti]

Hi All

How to make date from date field of attached sheet . Basically I want a Date field which has all the dates for the particular Month/Year present in the Date column of the sheet .

Regards

Shekar

[ahaahaaha · Accepted solution]

Hi,

try, for example

Date(Date#(Date, 'MMM_YYYY'), 'DD/MM/YYYY')

Creating all the dates I would have done in the loading script, like a normal Master Calendar (attached file, page 5).

Regards,

Andrey