addmonths and iterno function.

[#1]

Hi ,

my requirement is , when i select a particular date in datefield column, i need to generate a new column called pastdate having past 12 month's(MM) dates for the same DD.

right now, i am only able to generate 12 values, i need output of pastdate like this;

if i select 01-01-2015 (DD-MM-YYYY) from datefield then i should be able to generate 12 values in 'i' like this

01-12-2014

01-11-2014

01-10-2014

.

.

.

.

.

01-01-2014.

and i need to do it at script level only.

thanks.

[Peter_Cammaert]

Create an intermediate table between data and master calendar that is called "ASOF"-table.

Search the community: there are many threads discussing this kind of table.

Good luck,

Peter

[#3]

Hi peter , isnt it possible just by writing a script using addmonths function ?

[Peter_Cammaert]

Yes, that is the basic technique to create an ASOF-table.

Peter