Dates, auto-enter

[Locke]

I'm overlooking somthing kind of stupid and I need someone to point it out.

I have two Date formatted fields I'm working with:

1. Date Ordered

2. Date Needed

the Field representing "Date Needed" is supposed to be 14 days after the "Date Ordered" is entered. Here is the caculation I've written to do that:

Date(Month(WorkOrder_DateOrdered), Day(WorkOrder_DateOrdered) + 14, Year(WorkOrder_DateOrdered))

The initial "Date Ordered" is auto-entered by a script, however when this script is performed, it inserts the "Date Ordered", but will not insert my new "Date Needed" field until I manually tab through it. I wish to be able to have it automatically enter the "Date Needed" without any user involvement.

Anyone have some suggestions? Thanks much!

[Ender]

For the field definition of Date Needed, can't you just Auto-Enter a calc like: WorkOrder_DateOrdered + 14?

[Locke]

Thanks for the reply Ender. Yes, that works too. However, it still leaves me with the problem of having to tab through the "Date Ordered" field before it will populate the "Date Needed" field. It seems like there should be a simple solution to it, I just don't know it.

[Locke]

I just learned something and I indeed was overlooking something stupid. When I allowed the script to run and refresh the window, it actually did automatically enter it. The problem was that I was in browse mode and running the script to update only that particular field and do nothing else (for test purposes). Since the window wasn't being refreshed, it wanted me to tab throught the field it updated.

Thank you again Ender, I'm new at this.

[Fitch]

If Date Ordered is set with a script, why not set Date Needed with the same script?

Set field [ Date Ordered, Status (CurrentDate) ]

Set field [ Date Needed, Date Ordered + 14 ]