Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 8754 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

Hello Everyone,

I need to keep track of a user's call with a call #. Rather than use the "serial number" implementation, I would like to use the date plus an incremental # to keep track of each call every time a new record is created( e.g. 112120001, 112120002, etc.)

I hope this is clear..

thank you in advance

Posted

First, go ahead and create a serial field, call it Serial#. Then create a field based upon it as follows:

Call# (calculation, text, stored) =

Right("0" & Month(Status(CurrentDate)), 2)

&

Right("0" & Day(Status(CurrentDate)), 2)

&

Year(Status(CurrentDate))

&

Serial#

The reason I padded out the month and day is that:

11/1/2000 --> 1112000

1/11/2000 --> 1112000

Oops!

The running serial number would still make the resulting call numbers unique, but if you just used the date, you could have a problem! This is one of those easy problems that is hard to debug, if you have used a composite key to connect two related files. -bd

[This message has been edited by LiveOak (edited November 21, 2000).]

This topic is 8754 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.