Date Increment

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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]
 
Format([YourDate],"yymmdd") & "." & counter

Where "counter" is the value of the counter.

sam
 
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: (e-mail address removed)
 
Back
Top