Date Format

[dsc2bjn]

I wish to create a date which takes "Date()" and returns just the two digit
year portion converted to fiscal year starting in October.

I have tried several variations, but nothing seems to work.

 

[KARL DEWEY]

Try this --
FY: Format(DateAdd("m", 3, Date()), "yy")

 

[dsc2bjn]

I thought I had tried that...I must have mis-typed something.

THANKS!!

 

[dsc2bjn]

Ok...that works using a query to set a value, but...

I tried using it to set the default value of a control and it just says
#error.

 

[KARL DEWEY]

What kind of control and where? Did you preceed it with an equal sign?

 

[dsc2bjn]

I had it as a text box formated as a date/time field and tried both setting
the default value in the form and directly within the table.

Yes to the equal (when it was on the form).

I changed it to a number, but it drops the leading 0.

 

[KARL DEWEY]

I changed it to a number, but it drops the leading 0.
Numbers do not have leading zeros, only text.

 

[dsc2bjn]

True that...

I should have asked, how can I format the number to display as 08?

Or maybe I should just store the value as text, since I will only be using
the value to control which records to show on reports.

 

[KARL DEWEY]

Recomend text then not need to format for display.
But format number this way --
Expr1: Format([YourNumberField], "00") for two digit leading zeros.

 

[dsc2bjn]

Thanks!!

I changed it over to a Text field, since I will only be using it to sort
documents by the fiscal year to which they were entered into the database.

Again, Thanks!!

Recomend text then not need to format for display.
But format number this way --
Expr1: Format([YourNumberField], "00") for two digit leading zeros.
--
KARL DEWEY
Build a little - Test a little

True that...

I should have asked, how can I format the number to display as 08?

Or maybe I should just store the value as text, since I will only be using
the value to control which records to show on reports.