Zeros preceding a number

  • Thread starter Thread starter Kevbro7189
  • Start date Start date
K

Kevbro7189

I have this text field in a form which takes a date and displays the Julian
date of that date.

Jan 1 = 1
Feb 1 = 32
Mar 1 = 60
And so on. The text fields data is "=DatePart("y",[Date])." My problem I
need help with is I want that 1(Jan 1) to be displayed as 001, and 32(Feb 1)
to be displayed as 032. Can anyone help?
 
Kevbro7189 said:
I have this text field in a form which takes a date and displays the Julian
date of that date.

Jan 1 = 1
Feb 1 = 32
Mar 1 = 60
And so on. The text fields data is "=DatePart("y",[Date])." My problem I
need help with is I want that 1(Jan 1) to be displayed as 001, and 32(Feb
1)
to be displayed as 032. Can anyone help?
Click to expand...

=Right$("000" & DatePart("y",[Date], 3)))
 
Back
Top