Specific Days in Month

[wonkymeister]

Hi Guys,

something simple i'm sure - i need to Date() two 2 specific dates, 1st date from the previous month and the 2nd date from the current month. Getting the month is easy,=date((Date(MonthStart(AddMonths(Today(),-1))))) -- for previous month etc.

i need an IF statement for >= 18th (previous month) and <= 11th (current month)

struggling to code the specific days int he month.

cheers

[brunobertels · Accepted solution]

hi may be this 

18th day of previous month : 

date((Date(MonthStart(AddMonths(Today(),-1))+17)))

11th day of current month :

date((Date(MonthStart(Today())+10)))

[wonkymeister]

idiot i am - thank you