between function

Wed, 05 Nov 2014 00:38:46 GMT

I have table 1

name

date

I concatenated it

name & ' ' & date as name_date //this is a key

I have table 2

name1

datefrom

dateto

____________ as name1_date

Now, what i want is i want to create a key name1_date using concatenate,

in table 1 I have to pick up date and if it exists between datefrom and dateto only then i get the concatenated value of name1_date.

I need to do it in script.

Any directions?

Re: between function

Anonymous — Wed, 05 Nov 2014 00:46:33 GMT

Hi,

Use the inverval match to complete your requirement.

PFA.

Regards,

Chinna