datetime with decimal and percent

[Sara_Bertomeu]

Hello, I can't find the correct solution:

Trying to apply IF with a datetime data, and select %.

Thanks Sara

[Suvrutt_Gurjar · Accepted solution]

BK[Booked on]will result into a list of dates. It is being compared with a single date "1.6" , hence the error.

You will need to select an expression to give a single date value in place of BK[Booked on]. May be just [Booked on] if the column Cargos % is in the same table as BK.

[Sara_Bertomeu]

It's not the same table, whant can I do and this data [Booked on] it's a virtual one.

Sara

[Sara_Bertomeu]

Thanks @Suvrutt_Gurjar 

your ideas help me so much, I think I can find it with other data 

IF([Booked on]<"01/06/2022 00:00","0.011","0.109")

Solved. Using formula in Booked on: 

Who needs a soap opera having an appsheet!!!! LOVE IT!!!