If statement in two database fields, it is possible?

[Natalie]

Hello everyone,

I need to compare two field, basically:

if(Today()-FIELD1> FIELD2, 'wrong',
If(Today()-FIELD1> FIELD2, 'correct')) as THEFIELD;

but it is not working, if this can be possible, someone can explain how is the structure? LOAD/Resident etc....

in case of one field, works, but two no.

Thanks!

[petter · Accepted solution]

it seems to me that you should make the expression like this:

Hello everyone,

I need to compare two field, basically:

if(Today()-FIELD1> FIELD2, 'wrong', 'correct') as THEFIELD;