current date () to julian date (YYDDD)

karthi_gana · Post by **karthi_gana** » Mon Mar 07, 2011 4:50 am

All,

I would like to change the currentdate() format i.e YYYYMMDD to julian format (YYDDD).

I have searched here and i see the vice versa only.

nayanpatra · Post by **nayanpatra** » Mon Mar 07, 2011 6:14 am

I think the function JulianDayFromDate may help.

karthi_gana · Post by **karthi_gana** » Mon Mar 07, 2011 7:50 am

nayanpatra wrote:I think the function JulianDayFromDate may help.

it is nor working...my requirement is...oh..sorry...i think i wrongly mentioned my requirement in the subject..anyway...my requirement is

2011XXX where XXX = number of days of the year

i.e 2011066

chulett · Post by **chulett** » Mon Mar 07, 2011 8:03 am

Pretty sure if you check the docs that a mask of %ddd will get that for you.

karthi_gana · Post by **karthi_gana** » Mon Mar 07, 2011 8:38 am

i don't find it. can you provide me the syntax?

chulett · Post by **chulett** » Mon Mar 07, 2011 8:55 am

It's in the Parallel Job Developer Guide pdf, search for "%ddd" or "Date and time formats". In my version that starts on page 31.

karthi_gana · Post by **karthi_gana** » Mon Mar 07, 2011 8:55 am

chulett wrote:Pretty sure if you check the docs that a mask of %ddd will get that for you.

I have seen this in the below URL. But don't know to implement it. Can you give me the syntax?

http://publib.boulder.ibm.com/infocente ... tions.html

chulett · Post by **chulett** » Mon Mar 07, 2011 9:03 am

I said "formats" not "functions", if you clicked a little deeper you'll find them. And there's nothing magical about this, just do it like you would with any other date using DateToString().

karthi_gana · Post by **karthi_gana** » Mon Mar 07, 2011 9:16 am

chulett wrote:I said "formats" not "functions", if you clicked a little deeper you'll find them. And there's nothing magical about this, just do it like you would with any other date using DateToString().

exactly

That worked fine