Custom Date Format

[jwleonard]

I am attempting to show a custom julian date format in an unbound text box and am currently using:

=Format([DateOpened],"yy") & "" & Format(Format([DateOpened],"y"),"000")

This results in a format like 07117 which would be the 117th day of 2007.
I would like to trim the 0 from the front of the year so only the last digit of the year is left. Does anyone know of a way to do this?

 

[boblarson]

=Format(Format([DateOpened], "yy"), "0") & "" & Format(Format([DateOpened], "y"), "000")

 

[jwleonard]

Thanks, naturally that worked! I thought I had already tried that; guess I must have fat fingered it and not noticed.