Jump to content

Dates, auto-enter


Locke
 Share

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

Recommended Posts

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!

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 ]

Link to comment
Share on other sites

This topic is 6500 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
 Share

×
×
  • Create New...

Important Information

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