Less than greater than in set expression

[lalita_sharma]

Hi

I have a set expression as below

Aggr(only({$<[Date] = {'$(vDate_Current)'}, [Workstream Id]={$(vCalc_StatusPack_DefaultWorkstreamID)},[KPI name]={1},[M0 Finish Date]= {'$(=vDate_Current_temp)'}>} [M0 Description]),[M1 Description], [M1 Finish Date],[M1 RAG] ,[M0 Description], [M0 Finish Date],[M0 RAG],[Key Outcome])

In this expression [M0 Finish Date]= {'$(=vDate_Current_temp)'} works perfect, but when I try less than or greater than like below

[M0 Finish Date]= {'> $(=vDate_Current_temp)'}

It gives null result.  Can someone please help?

[stevejoyce]

[M0 Finish Date]= {">$(=vDate_Current_temp)"}

[lalita_sharma]

Even this gives null result

[M0 Finish Date]= {">$(=vDate_Current_temp)"}

[stevejoyce · Accepted solution]

Can you confirm [M0 Finish Date] is a date field in the model.

You can try this also to make sure its a date: ">=$(=Date(vDate_Current_temp))"

[lalita_sharma]

Thanks @stevejoyce . But this doesnt work. Even this gives same null result

[M0 Finish Date]= {">$(=vDate_Current_temp)"}

If I remove the greater than sign it gives results.

My data is like below:

[M0 Description]	[M0 Finish Date]
A	29-12-2023
B	12-02-2021
C	28-05-2021
D	17-12-2021
E	27-08-2021
F	30-12-2022
G	25-04-2022
H	17-12-2021
I	23-07-2021
J	23-07-2021

[lalita_sharma]

Thanks @stevejoyce 

This works perfect. 

Could you please help me understand what was the issue with earlier expression and why this one worked?

Is it because [M0 Finish Date] was date field and hence i have to convert vDate_Current_temp as well to date prior to any comparison?