Calculate Date Value

[#1]

I want to create a field that has the result of current date-scan date.

i.e; There is a field called Scan Date, which if doesn't fall within 21 days of current date, the result should be blocked, else unblocked. Tried different expressions but nothing is working.

[Mark_Little]

Hi,

I would add a flag in the load script.

Something like

IF(Today() - [Scan Date]) > 21, 0, 1) As showflag

then in your expressions you can just add {<showflag = {1}>}

Hope this helps

Mark

[alexandros17]

Try with

If(Num(Today()) - Num([Scan Date]) > 21,

0,

Num(Today()) - Num([Scan Date])

) As showflag

let me know

[#4]

Sure, I tried the ones that were mentioned earlier. Will try this and let u know. Thanks

[#5]

Can you give me the step by step how and where to do each step?

[alexandros17]

Open the expression and write the following:

If(Num(Today()) - Num([Scan Date]) > 21,

0,

Num(Today()) - Num([Scan Date])

)

[#7]

Thanks Alessandro. This works.

[alexandros17]

Could you please mark the answer? Thanks