Date Expression

[Anonymous]

Hi,

I am trying to exclude rows not required from my dataset but my expression does not seem to be working.

In data load editor I have created the below column:

IF(DATE(Exp_PODDate) = DATE(Today()),1,0) AS Exp_PODDateTODAY

I have then created the below expression using the above column:

=IF(Exp_PODDateTODAY = 1,Exp_PODDateTODAY)

Could someone please help with what I have done wrong?

Thanks

[jyothish8807]

Hi Raman,

Can you share a sample data or an app?

Br,

KC

[Anonymous]

Hi KC,

I have attached qvf file of app.

thanks

[PrashantSangle · Accepted solution]

date() is formatting function it will not round your date

try below

IF(DATE(floor(Exp_PODDate)) = DATE(Today()),1,0) AS Exp_PODDateTODAY

Regards,

[jyothish8807]

Hi Raman,

As per the data, i dont see "Exp_PODDateTODAY" with value 1. All value is 0.

Once you have value as '1' just uncheck "Include null Values"  for  Exp_PODDateTODAY in the table.

Br,

KC

[Anonymous]

Thanks!

I have the column and used the below expression:

Sum({<Exp_PODDateTODAY = {1}>}Exp_PODDateTODAY)