Data is not getting populated

[abc_18]

Hi ,

I am using below expression in a text box and  it's returning 0 values, but if I remove '$' sign I can see the data

=count({<builddate={"$(=date(max(builddate)))"},comp={'Compliant'}>}distinct [comp Id])

Please suggest what I am missing

Regards

[AshutoshBhumkar]

Hello,

Check for the date format of builddate.

Can you please show what is being calculated in the expression editor.

[abc_18]

Hi Ashutosh,

My date  is set to below format, and builddate is also displaying in same format only.

SET DateFormat='M/D/YYYY';

And this field I am directly using from table without any changes.

[AshutoshBhumkar]

Ok. Could you please provide a screenshot of expression editor ?

Need to check what is being calculated in the editor.

[abc_18]

Hi, above is the screenshot.

[AshutoshBhumkar · Accepted solution]

Try assigning date format to to the Date used in Set analysis.

=count({<builddate={"$(=date(max(builddate),'M/D/YYYY'))"},comp={'Compliant'}>}distinct [comp Id])

[abc_18]

Thanks it's working now.

I have a doubt, before without providing date format it was working fine.

Today I started getting  issue and after removing of '$' I am Getting the result.

[AshutoshBhumkar]

Okay. Must be any data format change from backend.

[abc_18]

Thanks Ashutosh, will check that, thanks.

But after removing '$' I can see the data, still need to be validate whether it's correct or not..

is it because of '$' returns current selection and whatever is applicable it's just displaying??

[AshutoshBhumkar]

Yes, It states all records in current selection.