Date Format

  • Thread starter Thread starter dsc2bjn
  • Start date Start date
D

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.
 
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.
 
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.
 
I changed it to a number, but it drops the leading 0.
Numbers do not have leading zeros, only text.
 
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.
 
Recomend text then not need to format for display.
But format number this way --
Expr1: Format([YourNumberField], "00") for two digit leading zeros.
 
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!!

KARL DEWEY said:
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


dsc2bjn said:
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.
Click to expand...
Click to expand...
 
Back
Top