Amanda Walshaw
asked on
changing julian dates in a sql view/query
in my apply_date field, document_date field, Invoice_date when I select the results are Julian dates,
I want to convert the Julian date to a calendar date.
ie Apply date
735054 - 05/07/2013
735054 - 05/07/2013
735053 - 04/07/2013
735053 - 04/07/2013
or would it better doing the conversion in excel
I want to convert the Julian date to a calendar date.
ie Apply date
735054 - 05/07/2013
735054 - 05/07/2013
735053 - 04/07/2013
735053 - 04/07/2013
or would it better doing the conversion in excel
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.