Default field with Single Digit Year within Julian Date

[Nixfmly]

I am trying to create a field with a default Julian date containing only a single digit year - example today 10/26/2016 = 6300

- I understand that both 2006 and 2016 will produce a 6, using the single digit year Julian Date- but it's what they use, so...here I am.

I have no issue creating the default date, but I cannot get to the single digit year. I have tried to format as "yyyyy" and "yyy" both of which provide 2016300

You're my only hope

 

[Joe4]

To get the single digit year, you can use:

Right(Format(Date(),"yy"),1)

 

[Nixfmly]

It may have been helpful if I had mentioned that I am working in a table

When I place your suggested formula in the Format field Property, it freaked out on me and turned into this "Rig"h"t(For"n"at("d"ate(),yy,),1"
It didn't work as planned...any other ideas?

 

[Joe4]

You wouldn't enter your desired default into the Format property, you would use the Default Value property.
However, I don't believe you can use formulas in setting Default Values for fields directly in the table like that.

You would have to control/set the Default Values upon Data Entry.
- In Data Entry is done manually, all data entry should be done through Forms, and you can use VBA on the Form (i.e. the "Before Insert" event) to set these values.
- In Data Entry is done by Import, you can run an Update Query after the data has been entered to calculate and set these values.