How to get Julian date
Posted: Fri Feb 10, 2012 6:07 pm
Hi All,
Would you please help me out? The below is my requirement.
In a report I have Julian date at 1st position and some text on 17th(9 bytes) column
I would like to get instances of text which is in 14th column, if 3rd position is having yesterdays Julian date.
input
output
Please help me out in this regards,
Many thanks for your anticipated help.
Regards,
Shailaja
Would you please help me out? The below is my requirement.
In a report I have Julian date at 1st position and some text on 17th(9 bytes) column
I would like to get instances of text which is in 14th column, if 3rd position is having yesterdays Julian date.
input
2012/039 RAJU
2012/039 KAVI
2012/039 SHYAM
2012/039 KAVI
2012/039 SHYAM
output
RAJU
KAVI
SHYAM
KAVI
SHYAM
Please help me out in this regards,
Many thanks for your anticipated help.
Regards,
Shailaja