Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
May be try this:
=Count({$<WEB_datainserimento ={"=Year(WEB_datainserimento) = Year(Today())"}>} IDWEB)
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.