Between function in a formula.

system · July 12, 2011, 2:43pm

Hopefully a quick one for the gurus… I have two relative date Objects ([first day of last month] and [last day of last month])

I would like to use these in a formula… such as =[something] where (([date]>=[first day of last month]) and ([date]<=[last day of last month]))

What is the correct syntax for this?

Thanks in advance for any help…

jaanse (BOB member since 2011-01-24)

system · July 12, 2011, 2:50pm

Hi,

Try this,

=[Something] Where ([Date] Between ([First Day of Last Month];[Last Day of Last Month]))

M H Mohammed (BOB member since 2010-06-16)

system · July 12, 2011, 2:52pm

Perfect, thank!

Seems obvious when you know how!

jaanse (BOB member since 2011-01-24)