Simple Date Array 1

[Simon9999]

Hi

I am using CRxi and SQL Server.

I would like to use a simple formula to evaluate if two seperate dates fall between a date range.

Rather than evaluating each date seperately I wanted to use a simple array, but am unsure what I should enter. My first attempt is:

if [date({BidEventDates.ITNdate}),date({BidEventDates.PQQdate})]
in {@start date} to {@End date} then "Y"

However this does not work, I believe this may be because the array produces to outputs.

Would appreciate any suggestions.

Thanks

Simon

 

[bdreed35]

I don't think you can use an array because you will still have to subscript it and specify one of them.
I think the only way is to test seperately.

if date({BidEventDates.ITNdate}) in {@Start date} to {@End date})
or date({BidEventDates.PQQdate}) in {@Start date} to {@End date}) then "Y"


~Brian

 

[Simon9999]

Thanks Brian,

Wasn't sure if it could be done or i just couldn't see.

Cheers