display the julian day using the system clock. (1 Viewer)

Q

QMDirk

Member

Local time

Today, 06:06

Joined

Nov 16, 2019

Messages

52

• Jan 5, 2020

• #1

Does anyone know the code to display the date as Julian in the format: yddd, using the system clock? I have tried variations on the 'Now() function but I'm missing something...thanks.

 

MajP

You've got your good things, and you've got mine.

Local time

Today, 09:06

Joined

May 21, 2018

Messages

8,525

• Jan 5, 2020

• #2

Based on your other post what you asking and what you want do not appear to be the same thing. The format "yddd" will be 5Sun (365Tue for 12/31/2019) where a single y is the julian day and ddd is the three letters of the day. But that does not appear to be what you want.

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 21:06

Joined

May 7, 2009

Messages

19,233

• Jan 8, 2020

• #3

this will return in the format yddd:

Code:Copy to clipboard

right(year(date),1) & format(datepart("y",date),"000")