Skip to Content
0
Former Member
Oct 06, 2016 at 07:33 AM

Month to Yesterday

60 Views

Dear experts,

I have written a report to show sales of MTD last year using the following formula which works well

if date({INVOICE_V.CREATED_DATE})>= date(DateAdd('yyyy',-1,Minimum(MonthtoDate))) and

date({INVOICE_V.CREATED_DATE})<= date(DateAdd('yyyy',-1,Maximum(MonthtoDate)))

then {INVOICE_V.INVC_NO} else 0

However, my client has asked if it's possible to show only sales of Month to Yesterday 23:59:59 as they do not want the current day of last year to be included.

Regards,

Fraser