generate a table of dates

[ali_hijazi]

Hello

I want to generate a table of dates that start from today and goes back until the first date of a year specified by number of years to go back

this number is to be taken from an input box on a sheet

thank you

[erichshiino · Accepted solution]

Hi,

I used the following script:

Table:

load date( makedate($(vStartYear))+rowno()-1) as Date

AutoGenerate( today()-makedate($(vStartYear))) ;

vStartYear is a variable available on an input box.

You can also check the attachment.

Hope it helps,

Erich

[kaushiknsolanki]

HI,

    I am here by uploading an example.

    I hope this is what you are looking.

Regards,

Kaushik Solanki