if

[raadwiptec]

hi

i have the following required in expression.. i have 3 columns

closing date

last date

opening date

My condition is as below

if closing date is blank or null the take the date from opening date column ,if the opening date is null or blank then take the date from last date column

[vcanale]

Hi,

Try to include in the condition all the possible values you can have, something like:

if(IsNull(Closing_Date) or Closing_Date='-' or Closing_Date='/',

    if(IsNull(Opening_Date) or Opening_Date='-' or Opening_Date='/', Last_Date, Opening_Date),   

               Closing_Date)

[Anonymous]

The problem with that approach is, what if there is junk in the field = something that's not a date you'll have to compensate for every conceivable scenario.

I the code I provided all field content is evaluated, and if it's not a date it'll be treated as null.