3 Replies Latest reply: Apr 23, 2009 3:10 PM by QV-Kjetil RSS

    Problems with Variable

    QV-Kjetil

      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)