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
Amanda WalshawBusiness Solutions AnalsystAsked:
Who is Participating?
PortletPaulConnect With a Mentor Commented:
try this:

  dateadd(day,apply_date - 693596,0)
-- and the other fields as required
from YourTable
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.