Date Increment

B

Bassel

Using a form I want have a field that shows todays date in the format
yymmdd.xx where xx is an increment starting from 01 and is rested each day.
For example June 27 2005
1st record 050627.01
2nd record 050627.02
What ever I try I get a slash "/" between yy,mm,dd.

Can anyone help me.
Best Regards
 
J

John Vinson

Using a form I want have a field that shows todays date in the format
yymmdd.xx where xx is an increment starting from 01 and is rested each day.
For example June 27 2005
1st record 050627.01
2nd record 050627.02
What ever I try I get a slash "/" between yy,mm,dd.

Can anyone help me.
Best Regards
Click to expand...

What is the datatype of this field? Text? Date/Time? Number? None of
the above are really appropriate; since you are storing two disparate
types of data (a date and a sequential number), you really should be
storing TWO fields, one for each. The Date/Time field can be formatted
yymmdd to display with no slashes.


John W. Vinson[MVP]
 
S

smk23

Format([YourDate],"yymmdd") & "." & counter

Where "counter" is the value of the counter.

sam
 
A

Allan Murphy

Bassel

Format your date field as yymmdd e.g. 050627 then use the mid$ function to
select the year, month and day from this field, then have another field to
hold
the new value as "year" & "month" & "day" & "." & " next sequential number"


Allan Murphy
Email: [email protected]
 
Top