I created a new database which contains a total of three fields. Two of these fields contain a drop down menu, while the third is a date field. When either of the two drop down menus have changed a new date should appear within the date field. The first drop down menu contains the shipping time, while the second is the method of shipping, UPS, Fedex etc. Could someone please point me in the right direction as to how to get this to work? Whatever help you can offer would be greatly appreciated. Thanks in advance.

Is the field stored or unstored?

... which contains a total of three fields.

The third field must be a date field which autoenters the modification date.

Hi Danielle,

while the third is a date field.

, of course he could have called a Date Field, and it really is text.

Lee

Hi Lee

of course.

This is why I said that that field "must be a date field"

BTW: even a text field can autoenter the modification date.

Unstored

How a date ( or a text ) field can be "unstored" ?

Did you mean: unindexed ?

Global storage is not selected. No Indexing.

Okay Bugsy,

We need to see a copy of the file, instead of playing 20 questions.

Lee

Pull Down Menu 1 (field 1):

- One week

- Two weeks

Pull Down Menu 2 (field 2):

- UPS

- Fedex

Field 3 (date)

- 00/00/2008

User selects from field 1 (ship date) and his/her method of shipping from field 2 (shipping method) a date is generated and placed within field 3 (arrival date). Hope this helps.

The third field must be a date field which autoenters the modification date.

You didn't say if this solution was good for you.

Field 3 (date)

- 00/00/2008

...

Hope this helps.

Not more than before...

Why Field 3 contains: 00/00/2008 ?

( that isn't a valid date )

The date field is auto-entered whenever a new record is created, however it changes when the user selects a different item from the drop down list. 00/00/0008 was only used to illustrate that a date field was used.

I have to go newly to an English school !

Your first post: "When either of the two drop down menus have changed a new date [color:red]should appear within the date field"

So we thought that that was your problem.

Your last post:"The date field is auto-entered whenever a new record is created, [color:red]however it changes when the user selects a different item from the drop down list"

So, what is really what you want ?

BTW: I still think that you need that the date field autoenters the "modification" date, not the "creation" date

Re-reading and re-reading and re-reading this post, I finally discovered that you never said that the new date must be the current one !

So I went to read all your older post and there was only one ( ambiguos ) that, with this one, is more understandable.

IF

the due date must be: release date + 10 on creation

BUT

must change to: release date + weeks + shipping method

THEN

due date autoenters this calc:

Case(

IsEmpty ( weeks ) or IsEmpty ( shipping method ) ; release date + 10;

weeks = "One week" or shipping method = "UPS"; release date + 9;

weeks = "Two weeks" and shipping method = "UPS"; release date + 16;

weeks = "One week" and shipping method = "Fedex"; release date + 11;

weeks = "Two weeks" and shipping method = "Fedex"; release date + 18

)

Note that 9, 16, 11, and 18 are sure incorrect numbers of days, but I need them for this example.

Attached an example file

BugsyOhar_problem.zip

Thanks for all your help in interpreting my bad english. Everything appears to be working with one exception. Based on your example the owner would like to have the ability to manually change the due date and have the release date reflect an earlier time frame. Looking at your calculation, is this something that can be easily added?

due date = release date + 10

so:

release date = due date - 10

If you want that earlier result to appear into the field: release date, you'll have to set an auto-enter calc ( always evaluate ) even for that field...

A calc of this type:

Case(

Get(ActiveFieldName) = "due date"; due date - 10 ;

release date

)

-----------------

AND

to add a line to the Case ( ) function of the due date calc:

Case(

[color:green]Get(ActiveFieldName) = "due date"; due date ;

IsEmpty ( weeks ) or IsEmpty ( shipping method ) ; release date + 10;

weeks = "One week" [color:red]and shipping method = "UPS"; release date + 9;

weeks = "Two weeks" and shipping method = "UPS"; release date + 16;

weeks = "One week" and shipping method = "Fedex"; release date + 11;

weeks = "Two weeks" and shipping method = "Fedex"; release date + 18

)

P.S.: [color:red]and ( not or ): that was a typo into my earlier calc

Thanks again for your help on this project. It seems every time a problem is solved, another request is being made. On the creation of a new record, is there a way to auto-enter a date into the release date field while also increasing it by an additional 10 days on record creation given the added calculation?

Yes, it just do it !

Release date must have two option:

autoenter the creation date

AND

autoenter the above calc.

I have it setup exactly as you stated. The field release date has both the autoenter of the creation date as well as the calculation. When a new record is created the release date is showing todays date (9/4). It's not adding the additional 10 days to the release date field. On the creation of a new record, the release date should indicate a date of 9/14.

Maybe we haven't so much feeling !

Wasn't due date to be release date + 10 ?

BTW: change the two autoenter options to only one with this calc:

Case(

Get(ActiveFieldName) = "due date"; due date - 10 ;

Get(CurrentDate) + 10

)

Perhaps I'm doing something wrong. The calculation changes have been made but on the creation of a new record todays date still appears. Could you apply the changes to the file you sent earlier? Maybe my mistake is in the coding.

I wish to see your file, instead.

Post it.

Could you try this?

f3.calc= Evaluate ( "f1+30" ; [f2])

where

f1 is your date field

f2 is your method

f3 enters the f1 date plus 30 days when the value in f2 changes

Jon

When the user request a new record, the release to printer field should display the date 10 days after the date of record creation. See attached file.

Project_Tracker2.fp7.zip