Date Function

[Former Member]

Hi,

I want to determine a fixed period of time in an input field. It should show the current month (for example March 2008) to the same month two years ago (March 2006), so that the table displays the values of March 2008, March 2007 and March 2006. How should the Formula look like?

Thanks.

Kind Regards!

[Former Member · Accepted solution]

The formule you can use is : DSTR(DADD(NOW(),-1,'Y'),'MON YYYY')

By the DADD function you can change the date (you can choose to change the Year and how), and by the DSTR function you can set the format you want to present your date.

In this case the output will be "Mar 2007"

Hope, this will help.

Regards,

Luba.