error in expression

[marcorizzo]

Hi.

I'm trying to write an expression like this:

=count({$<year(WEB_datainserimento)={year(Today())})>}IDWEB)

but it doesn't work.

I'm not finding the mistake.

Any suggestion ?

Thanks

Marco

[sunny_talwar]

May be try this:

=Count({$<WEB_datainserimento ={"=Year(WEB_datainserimento) = Year(Today())"}>} IDWEB)

[vishsaggi · Accepted solution]

Hi Marco,

If this field stores the dates, why dont you create an extra field in your load script and then use that field in the expression.

Like try this.

LOAD *,

         Year(WEB_datainserimento) As WEBYear

FROM <YourTableName>;

Expression:

=count({$< WEBYear = { "=year(Today())" } >} IDWEB)

Thanks,

V.