6 months to date

[#1]

Hi All

I'm trying to write in my script a quick date value-  ' 6 month to date'

I add other values that I am  using in my calender like the following quick dates:

example for this week:

load

     fulldate,

     'this week' as quickdate

     Resident Calendar

     where fulldate>= WeekStart($(vToday))

     and FullDate <= $(vToday);

so how can I calculate 6 months to date??

I really appreciate your help

Thanks in advance!

[sushil353 · Accepted solution]

Hi,

do you want to get past six month data in script loading or in expression in chart.

in either case you can use Addmonths() function to go back 6 month back.

for example : Addmonths(datefield,-6)

HTH

Sushil

[#3]

Thank you so much!