Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try =count ( { < Working_Date = {'>$(=num(today()))'} >} CLIENT_NO)
Try =count ( { < Working_Date = {'>$(=num(today()))'} >} CLIENT_NO)
Brilliant - Thank you so much for for your help!
Brilliant - Thank you so much for your help!!
try this
=count ( { < Working_Date = {'>$(=num(today()))'} >} CLIENT_NO)
Thank you