Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Problems with Variable

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)

Tags (1)
1 Solution

Accepted Solutions
jsn
Honored Contributor

Problems with Variable

Another way of getting the first day of the previous month compared to todays date is this:

LET ToMonth = monthstart(addmonths(Today(),-1));

3 Replies
Not applicable

Problems with Variable

I found the answer. So stupid! forgot the ;

jsn
Honored Contributor

Problems with Variable

Another way of getting the first day of the previous month compared to todays date is this:

LET ToMonth = monthstart(addmonths(Today(),-1));

Not applicable

Problems with Variable

Thanks!

Community Browser