Expand my Community achievements bar.

SOLVED

Julian Date for use in Document ID

Avatar

Former Community Member

Can anyone show me how I can convert a date field into a Julian date(YYDDD)? Essentially I just want to have this converted into a variable that I will concatenate with other values that will be used in generating unique doc ID.

Additionally anyone have thoughts on how I can ensure the doc ID is globally unique w/o using getUID?

I have never done anything with a Julian date before so I am at a loss.....

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi,

to display a julian date you can use the J symbol in your display pattern:

date{YYJ} to display January the 3rd 2015 as 153 (3rd day in 2015)

or

date{YYJJJ} to display January the 3rd 2015 as 15003 (with leading zeros)

To reuse the formatted Date in a script use the formattedValue instead of the rawValue.

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

Hi,

to display a julian date you can use the J symbol in your display pattern:

date{YYJ} to display January the 3rd 2015 as 153 (3rd day in 2015)

or

date{YYJJJ} to display January the 3rd 2015 as 15003 (with leading zeros)

To reuse the formatted Date in a script use the formattedValue instead of the rawValue.

Avatar

Former Community Member

‌radzmar,

WOW!! That was a lot simpler than I thought it would be.

Thanks for the help.

J