Convert dates to Julian format

rajmohan · Post by **rajmohan** » 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

chulett · Post by **chulett** » Tue Dec 21, 2010 12:36 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 21, 2010 4:42 am

Code: Select all

Oconv(Iconv(InLink.TheDMYDate, "DDMY"), "DMADY")