Posted: Mon Dec 20, 2010 11:53 pm
how to change the date format dd/mm/yyyy to julian format in server job
for example 15/03/1985 to march 15 1985
for example 15/03/1985 to march 15 1985
Rajmohan, I split this question from the completely unrelated post in the General forum that you added it to for some reason. Please take a moment and edit your post to add the relevant details for us - version, O/S, etc. They are only prompted for when you start a new conversation with the Post new topic button which is the action you should have chosen.
Date conversions in Server are done with the IConv and OConv functions, typically used in pairs - first to convert the original date to internal format and then back out to desired new external/output format. And FYI - your example target format is not a "julian" date, but rather a transition from "DMY" to "MDY" with the full month name.
I'll leave it to others to dig up the appropriate syntax for that, not one that I know off the top of my head and it's past my bedtime.