Hello,
I have the following set analysis expression which brings relevant records but not within specified date range. I think this is due to different date formats and need help to fore came date format within the expression:
Count({$<[Report Source Type]={'Marketing'}, [Receipt Date]={'>=$(%StartDate)<=$(%EndDate)'}, [Partner Source]=>} [ReportID])
[Receipt Date] has format: 'DD-MMM-YYYY'
%StartDate and %EndDate have format: 'dd/mm/yyyy'
Can I format either date(s) in the expression itself?
Thank you,
Sokol
