Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
good day
currently I have an published report that pulls data for the current month.
the filter field being used is =only({=$(=Date((Today() )))}YearMonth)
I'm relatively new to nprinting and sql, how can this formula be changed to get the Prev Months data.
for example it runs now from 1Dec to 31 Dec
but the require 1 Nov to 30Nov
thanks
create a a max month-1 in the data and you will get the last month data
same use that column in filter then you will get the expected data
Hi,
You can add this expression in the filter condition
Month(Today())-1
this will take to prev month data.