Set expression of date that is less than today's system date

[Shubhangi_01]

Hello,

I need to take out percentage of date values which are less than today's date against total number of project count using Set expression.

I tried this :

=Count({$<([Launch Date])<{">=$(=Date(Today(), 'YYYY-MM-DD'))"}>}) / Count(DISTINCT ProjectID)

But this is throwing error.

Any help appreciated. Thanks in advance.

Regards,

Shubhangi

[Taoufiq_Zarra]

I think you forgot the measure: "count" of what? in Count({$<([Launch Date])<{">=$(=Date(Today(), 'YYYY-MM-DD'))"}>}) 

Taoufiq

[Shubhangi_01]

Hi,

I want count of Launch date which are less than today's date.

Can you help me in forming the expression?

Thanks in advance.

Regards,

Shubhangi

[Taoufiq_Zarra]

can you share the sample data

[Shubhangi_01]

Hi,

Please find the attached Sample data file.

Thanks,

Shubhangi

[Taoufiq_Zarra · Accepted solution]

Hi,

you forgot to mention [Launch Date],

but if I add the file header, the loading script:

so, the funcion becomes

='count of Launch date which are less than todays date :'& count({<"Date([Launch date])" = {"<=$(=MakeDate(Year(Today()),Month(Today()),Day(Today())) )"}> } Code)

and the result :

but be careful with null dates

Cheers,

Taoufiq

[Brett_Bleess]

Did Taoufiq's last post get you what you needed?  If so, do not forget to come back to the thread and use the Accept as Solution button on that post to give him credit for the assistance and let other Community Members know it worked.  If you are still working on things, leave an update as to what you still need.

Regards,
Brett