how to write > expression

[kunkumnaveen]

Hello All,

i am trying to count only those IntermID whose VALIDTO  date has to be greater than today,i tried below expression ,i am getting 0 as o/p,anything  wrong with my expression.

count(DISTINCT{<VALIDTO = {'>$(=Date(today()))'}>}IntermID)

thanks

[kunkumnaveen]

Add on to above requirement

Valid date formate

Date(VALIDTO,'DD-MM-YYYY') as  VALIDTO, 

[Anil_Babu_Samineni · Accepted solution]

May be this

count(DISTINCT{<VALIDTO = {">$(=Date(today(),'DD-MM-YYYY'))"}>}IntermID)

[sunny_talwar]

Or just use Date() function in the script while creating VALIDTO field like this

Script

SET DateFormat='DD-MM-YYYY';

Table:

LOAD ....

    Date(VALIDTO) as  VALIDTO,

...

FROM ....

and then this

Count(DISTINCT{<VALIDTO = {">$(=Date(Today()))"}>}IntermID)

[calvin_wee]

I have similar issue using the following. Any advise?

COUNT({<[Received Date]={">$(=DATE(WeekStart(today()),'DD-MM-YYYY'))"}>} [Request No])