Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Use the inverval match to complete your requirement.
PFA.
Regards,
Chinna