Getting Number of Days from the 1st of the year.

[m_muia]

I have been trying to get the number of days from the first of the year. I have tried using the Julian Date Function, but it does not appear to be what I was expecting. I have tried several other functions, but they have been unsuccessful. DaysSinceFromDate(%date%,%yyyy-mm-dd%) gives me compilation errors, I guess that the syntax or the source fields I am using may be incorrect. :?:

[amsh76]

What is the format of your input Date ?

[m_muia]

What is the format of your input Date ?

The Date format is 'yyyy-mm-dd'

[amsh76]

Of top of my head...what i can suggest is

Convert your input date in Internal Format through Iconv
and then convert that to Julian..through Oconv.

[ArndW]

I would use

Code: Select all

JulianDayFromDate(today())-(JulianDayFromDate("01/01/2005")

(wishing that I could use Iconv & Oconv in PX!!!!! You could always use a BASIC transform stage and utilize the Iconv/Oconv capabilities of the Server edition, but you would lose some of the performance advantages of Px)

[richdhan]

Hi,

I have used the DaysSinceFromDate function and it works perfectly. This is the syntax I used in the transformer

DaysSinceFromDate(CurrentDate(), DSLink2.FirstDay)

where DSLink2.FirstDay has been initialized to '2005-01-01'.

HTH
--Rich

Pleasure in job brings perfection in work

[T42]

Didn't people around here learn anything from Y2k?

NEVER EVER HARD CODE VALUES IF YOU CAN HELP IT!

Here's your answer:

Code: Select all

YearDayFromDate(StringToDate(field, "%YYYY-%MM-%DD"))

This works for 7.1r2 (Just tested this.)