dates

[crazybake]

I know this has been addressed many times..but...

I have a group of buttons each that has a date on it using <<status(currentdate)>> and the next 13 days.

I guess I don't understand how to use this function or the Today function. I want these buttons to show today's date and the next 13 days. It works if you select a record that was created today. However, if I select a record that was created two days ago, the buttons change so that "today" has the date of the job two days ago... Ho do you keep these buttons so that they always show todays date, plus the next two weeks no matter which record has been selected..

On another note... If I have a dropdown menu which has the next two weeks listed as 1/10/03 etc. How do I get them to show up in correct date order (i.e. 1/1/03, 1/2/03) instead of numerical order (1/1/03, 1/10/03)?

thanks

[kenneth2k1]

Sounds like the calc fields that you have set up as buttons are basing their dates off the record creation date. These calcs should be changed to read:

Status(CurrentDate) + 1

Status(CurrentDate) + 2, etc

You can make them unstored calcs.

As for the second question, what is the list based off?

Ken

[CobaltSky]

You haven't said, but I am guessing that your buttons which have dates on them are derived from calculating fields. That being the case, the problem is likely that the calculations are stored. That being the case, if you set them to unstored, you will find that they refresh each time they are displayed.

Your second proiblem is a little more tricky. Custom value lists sort in a custom order, but I'm guessing that your list is automatically generated - perhaps also by calculation. If so, the problem is likely that the calculation field generating the dates is a text field, adnd therefore a text sort order is being applied to the value list based on it.

If so, you should be able to get the value list to sort in date order by using a calculating date field as the basis of the value list instead. I suggest that you create a stored calculation or desult type date with a the formula along the lines of:

Case(Status(CurrentRecordNumber) < 15, Today + Status(CurrentRecordNumber))

The only limitation of this approach is that it will not produce a full two weeks of dates until/unless you have at least fourteen records in the file.

Another consideration is that, as it uses the Today function, it will automatically recalculate the first time the file is opened on a given date. If the file is left open indefinitely (eg running 24/7 on a server) then the Today function will not automatically update, and you'll need to devise a script to trigger the updates.