Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Julian Date for use in Document ID

josh12468112
Level 2
Level 2

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
radzmar
Correct answer by
Level 10
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
radzmar
Correct answer by
Level 10
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

josh12468112
Level 2
Level 2

‌radzmar,

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

Thanks for the help.

J