MTD last year

[dollipi]

Hello,

Need MTD from last year.

Have this for MTD:

Data Item named [Invoice extract]:
extract(month;cast([XDATEX];date))

+ 2x promt:

1)

[Invoice extract] = (extract(month;current_date))

2)

[XDATEX] between 2017-01-01 and 2017-12-31


How I can get MTD for last year in one query?

Thanks,

dollipi

[BigChris]

[YourDateField] between _make_timestamp(year(current_date)-1,month(current_date),1) and _make_timestamp(year(current_date)-1, month(current_date),day(current_date)

...or something like that anyway  :D I haven't got cognos on this machine so I can't check for sure.

[dollipi]

it doesn't work :(

[BigChris]

Error messages?

[dollipi]

no figures....