topic Re: Specific Days in Month in App Development

Specific Days in Month

wonkymeister — Thu, 27 Jan 2022 10:11:18 GMT

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

Re: Specific Days in Month

brunobertels — Thu, 27 Jan 2022 10:34:32 GMT

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)))

Re: Specific Days in Month

wonkymeister — Thu, 27 Jan 2022 10:37:06 GMT

idiot i am - thank you