Hi, in Zoho Reports I added a formula column with this If statement:

If("Fecha">='19/10/2018', 100, 10)

The field Fecha is a date field.

What I want to do is that all records that have a date that is equal or greater than 19/10/2018 should have in that column a value of 100, the ones that are less than that date should have a value of 10.

My problem is that all records appear with a 100 value in them, instead of the corresponding ones.

My DB have records since 16/10/2017 up to date.