LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: khopkins

Hello everyone,

Does anyone know of a way i cant take any given date and return the actual day number of the given year in the date?

For example if the date was 25/12/2012 then i would expect the day number to be 360

Regards,

Keith

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

Let's say that you have a field containing the date named "myDate"

compute a new value for Jan 1 of that year:
newYears = date(year(myDate),1,1)
then use dateSubtract
julianDate = dateSubtract(myDate,newYears)+1

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: khopkins

Thanks Stony
Perfect