Help with syntx conversion

[helen_pip]

Hello

I know what I would like to achieve in Qlikview, but require some assiatcne with a conversion to qlikview syntax

It is a between statement and the syntex that I would require help with is:

If(Today()-1 between admission_date and Today()-1, 1)

Anyone able to help

Kind Regards

Helen

[sunny_talwar]

Not sure I understand what you mean by this -> Today()-1 between admission_date

Can you may be share a few lines of sample with the expected output?

[Peter_Cammaert]

This is a weird requirement, as your test value is at the same time the outer boundary of your range. This makes the IF always result in true(). So your code boils down to:

IF (true(), 1)...

[swuehl]

If yesterday is between admission and yesterday?

Isn't that always true (or false, depending on how you look at the borders of your between range)?

[Kushal_Chawda]

this?

if( admission_date <= today()-1,1)

[Anonymous]

You can try this, it wud give you same:

If(Today()-1 >= admission_date, 1)

[buzzy996]

hey,u have to explain a bit more ur expected out ..that helps qlickers to respond quickly.