Pull data by Date 1

[bdjb]

I am pulling data based upon a date field, now they would like the next full month, plus 14 days (so basically a month and a half). Any pointers on how to do that based upon a date field?

Thanks in advance!

 

[briangriffin]

This returns 6/15/2012 for today, or any date in April.

dateadd("M",2, minimum(MonthToDate)) + 14

 

[bdjb]

Thank you, that gave me the answer I needed. When run anytime during the current month, it will give the next full month plus 14 days

{TODOAPPT.StartDtAct} In dateadd("M",1, minimum(MonthToDate)) to dateadd("M",2, minimum(MonthToDate)) + 14