Hi all, I am trying to compare the date field of two files: one uses the day of the year format yyyyddd and the other uses mmddyyyy. Both fields are defined as decimals. I can convert mmddyyyy to yyyymmdd but I don't know how to convert it to day of the year or vice versa using SQL.
I've done some searching and found some old posts where they have a somewhat complicated math to convert the seven-digit Julian date but I was hoping that something better has become available since those posts were made.
Some background:
File A uses a seven digit decimal field as a dare field with the format yyyyddd
File B uses a nine digit decimal field as a date field with format mmddyyyy
I need to extract all records in File A where the date is equal to the date on File B.
I've done some searching and found some old posts where they have a somewhat complicated math to convert the seven-digit Julian date but I was hoping that something better has become available since those posts were made.
Some background:
File A uses a seven digit decimal field as a dare field with the format yyyyddd
File B uses a nine digit decimal field as a date field with format mmddyyyy
I need to extract all records in File A where the date is equal to the date on File B.
Comment