Date Conversion

[bucks]

Hi,
I need convert a date format which is year and a day ex:-2007045 to a format 2007-02-14.

can anyone help me regading this?

Thanks !

[kumar_s]

Hi and Welcome to Dsxchange :D !!!!!

Try using

Code: Select all

StingToDate(Input.field, "%YYYY%DDD")

[Mohanram]

HI ,
Try it using iconv and Oconv function..
ex:if the date is 2007032 which represents 2007-02-01
use the below mentioned function in the transformation stage


OCONV(ICONV('2007032','DYD[4,3]'),'D-YMD[4,2,2]')

[DSguru2B]

The input looks like Julian date to me. Try

Code: Select all

DateFromJulianDay(in.Date)

ICONV/OCONV is not present in parallel jobs unless you use a basic transformer.

[chulett]

Technically, that's actually an 'Ordinal' date - the year followed by the number of the day within that year. However, from what I recall, that DateFromJulianDay function is actually expecting an Ordinal date.

[DSguru2B]

Your right Craig. Somehow 'they' got the naming wrong for the function.

[bucks]

Thanks kumar and for all the replies,

I have used lengthy procedure for this conversion using function DateFromDaysSince(), using stage var.


Funny thing is, it worked with simple StringToDate(datefield,"%yyyy%ddd").

[kumar_s]

Hi Mohan,

Iconv/Oconv are BASIC function used in Server jobs, and Basic Transformer in PX jobs which are seldom used.

[kumar_s]

Thanks kumar and for all the replies,

I have used lengthy procedure for this conversion using function DateFromDaysSince(), using stage var.


Funny thing is, it worked with simple StringToDate(datefield,"%yyyy%ddd").

Do you mind marking the post as resolved.