using "between" function within switch

[drewetzel]

Hi,



I'm sure the answer is staring me in the face, but I'm at a loss. I'm using the simple test expression below to assign a value of 1 to records with [saledate] between the two dates indicated in the code below and I'm just getting a null result. Can the between function not be used in this way?

Hughes Test: Switch([saledate] Between 1/1/2014 And 3/14/2014,1)

Thanks,
Andrew

[Xipooo]

ooops.. forgot he was using the function...

[Xipooo]

You probably need #'s around your dates.

[drewetzel]

huh? That doesn't seem to be very helpful

[drewetzel]

oh, just saw the second reply. they're usually added automatically, but lemme check that

[drewetzel]

wow....that was it. Haha, I'm so used to them being added automatically in expressions, I didn't even snap to that.

[Xipooo]

huh? That doesn't seem to be very helpful

Yeah sorry about my first comment. At first I thought you were trying to use the C expression... I was going to mention you should use the "Select Case", but then I realized you were using the switch function.