DSXchange

Hi eze_ke, May be space is missing between date and hours while giving the syntax: StringToTimestamp(stg1,"%yyyy-%mm-%dd %hh:%nn:%ss") I had used 2 stage variables as given by you: stg1 = stg[1,4]:"-":stg[5,2]:"-":stg[7,2]:" 00:00:00" stg = '20071109' ..and th...

I was sure that the output would be 2 records. Still for it, I just tried a sample to check and I got the output as desired. pp, you probably need to check that you have done a 'sort' and 'hash' on keys. As others have suggested, please check for the column names 'coz column should match exactly. ~ ...