Hello and thanks!

When my file opens a script is run which creates a new blank record and populates a field with the Date of creation.

What I need is a second field to be populated a certain way based upon a time range from the date created field.

example:

If the record is created between 07:45 AM and 08:15 AM, then a field named "SHIFT" will be populated with text that says "Dayshift - 0800-1600".

Is this possible? Thanks again.

Edited May 12, 200916 yr by Guest

there are probably any number of ways to do that and i'm sure someone here will come up with something really elegant.

if you just have a few of those shift slots, it might be easy to just use a second field which auto-enters the creation time. it doesn't need to be on the layout. then, in your script, you can have a case statement like this:

case (

timeIn > time (7,44,00) and timeIn < time (8,15,00, "Dayshift - 0800-1600"),

[similar expressions for more shifts],

NightSift - 2300-0800")

Edited May 12, 200916 yr by Guest

Thanks so much for taking the time. I will try your idea. I actually have created the "Time created" field and it is not in the layout. I figured I would need to have it for the script but I am new enough to scripting that I don't know how to write it.

Thanks again. I will let you know.

B

I guess I have a lot of learning to do yet. When I tried it, I got a popup message that said "The specified file cannot be found".

I'm lost.

Unless one of you can guide me through the actual process, I think I should do some more reading because I may have the cart before the horse.

Thaks again

B