Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Why do I get a error on this one in QV 8.5 ? Anyone got some other idea of writing the first day of last month in the following date format 01-mar-2009?
LET ToMonth=left(date(monthstart(TODAY(),-1),'DD-MM-YYYY'),2) && '-' && month(date(monthstart(TODAY(),-1),'DD-MM-YYYY')) && '-' && right(date(monthstart(TODAY(),-1),'DD-MM-YYYY'),4)
Another way of getting the first day of the previous month compared to todays date is this:
LET ToMonth = monthstart(addmonths(Today(),-1));
I found the answer. So stupid! forgot the ;
Another way of getting the first day of the previous month compared to todays date is this:
LET ToMonth = monthstart(addmonths(Today(),-1));
Thanks!