Issue with date in set expression

[#1]

Hi,

Can someone please help me with below set expression.

I'm having trouble with  [Expected Funding Date], I want it to be today() -1:

sum({<  [Transaction TFS Status Desc]  = {'Funded','Lost','Rejected'},
        [Expected Funding Date] = {'< =$( today()-1)'},
        [Transaction Status Date Num]   = {'>=$(v12MonthsAgoStart)'}      
>}USD)

[Clever_Anjos · Accepted solution]

You should format the output of today()

[Expected Funding Date] = {"<=$(=DATE(today()-1,'MM/DD/YY'))"},

[#3]

Thanks Anjos.. Appreciate your help.

[sunny_talwar]

Try this may be:

=Sum({<[Transaction TFS Status Desc]  = {'Funded','Lost','Rejected'},

        [Expected Funding Date] = {"$(='<=' & Date(Today()-1, 'MM/DD/YYYY'))"},

        [Transaction Status Date Num]   = {'>=$(v12MonthsAgoStart)'}>}USD)