difference between number days between two date fields

[#1]

Hi All,

  is this if else condition is fine??I do not get any value,getting blank,any suggestions

If

([VAR ETO] = 'ETO',
Today()-'RDDate',If([Item Category]='ZSPK' or 'ZSK1',today()-'GID of FPDdate',Today()-'GID of RDDdate'))

Thanks

[Anonymous · Accepted solution]

Hi,

it looks like there are strings when there should be fields?

If ([VAR ETO] = 'ETO',
Today()-RDDate,If([Item Category]='ZSPK' or [Item Category]= 'ZSK1',today()-[GID of FPDdate],Today()-[GID of RDDdate]))

hope this helps.

Best regards

Stefan

[maxgro]

try with

=

If([VAR ETO] = 'ETO',

     Today()-[RDDate],

     If(     match([RDDate], 'ZSPK', 'ZSK1'), today()-[GID of FPDdate],

             Today()-[GID of RDDdate]

     )

)

[aveeeeeee7en]

Try this:

If([VAR ETO] ='ETO',Num(Today())-Num(RDDate),

If(Match([Item Category],'ZSPK','ZSK1'),Num(today())-Num(GID of FPDdate),Num(Today())-Num(GID of RDDdate)))

Regards

Av7eN

[#5]

Thank you..looks good