Problem with date in set analysis

[#1]

Good Afternoon all,

I have the following code in my load script in QV11.

num (SECTION_DATE) as Working_Date

and have tried the following piece of set analysis

=count ( { < Working_Date = {'>num(today())'} >} CLIENT_NO)

However this brings back 0.

If I hard code the integer for todays date currently 41422

=count ( { < Working_Date = {'>41422'} >} CLIENT_NO)

I get the correct result

Can anyone advise why the num(today()) funtion is not working in my set analysis please?

Many thanks in advance

Mike

[Gysbert_Wassenaar · Accepted solution]

Try =count ( { < Working_Date = {'>$(=num(today()))'} >} CLIENT_NO)

[#3]

Brilliant - Thank you so much for for your help!

[#4]

Brilliant - Thank you so much for your help!!

[#5]

try this

=count ( { < Working_Date = {'>$(=num(today()))'} >} CLIENT_NO)

[#6]

Thank you