Syntax issue?

[cbaqir]

Hi QV Community...

I am trying to understand why this works:

round(Sum({$<FISCAL_YEAR=>}FCST_AMT), 1000)/1000

But this doesn't:

round(Sum({$<FISCAL_YEAR=,APP_DATE={">$(=today())"}>}FCST_AMT), 1000)/1000 

I want the same data but only if APP_DATE is greater than today. The data is valid in my dataset.

Thanks,

Cassandra

[swuehl · Accepted solution]

Have you ensured that today() returns a date format that matches the format of APP_DATE?

Maybe you need to format the result of today() using Date() function.

[cbaqir]

Thanks. So what would that syntax look like?

round(Sum({$<FISCAL_YEAR=,APP_DATE={">$(=date(today(), 'MM-DD-YYYY'))"}>}FCST_AMT), 1000)/1000 

[petter]

Round(Sum( {$<FISCAL_YEAR=,APP_DATE={">$(=Num(Today()))"}>} FCST_AMT ) , 1000 ) / 1000

Turns the Today() into a date serial number which should be safe from formatting issues....