Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
VLN_Date is made up from the filename. I have
12-11-2018
19-11-2018
26-11-2018
03-11-2018
10-12-2018
17-12-2018
I only ever want the last weeks so I need the 17th and the 10th in this case.
count({<VLN_Date = {'$(=Max({1}VLN_Date))'}>}Description) - THE CURRENT WEEK 17TH
COUNT({< VLN_Date = {"$(=Date(Max({1}VLN_Date)-7, 'DD-MM-YYYY') "} >} Description) - THE PREVIOUS WEEK 10TH
Of course this doesn't want to work for me.
Any help appreciated.
Can you try this
Current Week
Count({<VLN_Date = {"$(=Date(Max({1}VLN_Date), 'DD-MM-YYYY'))"}>}Description)
Previous Week
Count({<VLN_Date = {"$(=Date(Max({1}VLN_Date) - 7, 'DD-MM-YYYY'))"}>} Description)
Can you try this
Current Week
Count({<VLN_Date = {"$(=Date(Max({1}VLN_Date), 'DD-MM-YYYY'))"}>}Description)
Previous Week
Count({<VLN_Date = {"$(=Date(Max({1}VLN_Date) - 7, 'DD-MM-YYYY'))"}>} Description)