Fortnight Value List

[Alex K]

I am creating a scheduling solution and would like a drop down menu displaying todays date and the next 13 days ie. a fortnight - this should automatically change every day.

I've tried using a calculation for the value list eg. "today + 1 & ¶ & today + 2 etc..." this works but does not update correctly (the oldest date remains in the list) and the list displays the dates in format eg. "14/2/06" but displays "Tue, 14 Feb 2006" when I click off it.

I tried various formatting but can't seem to sort it out - I'm sure there is a more elegant solution.

Help would be appreciated.

Cheers.

[RalphL]

Is your caalculation set to be unstored?

[comment]

Make sure your calculation is result is set to Text - a Date field cannot hold more than one date.

IIRC, the Today() function updates only when you close and re-open the file? Use Status (CurrentDate) instead, and make sure it's unstored.

[Alex K]

Thanks comment,

but I still must be doing something wrong.

When I select the drop down I get .

I've tried various "trial & error" methods and still have problems ie.

1. the date list is not in chronological order.

2. the list does not show the date in the format I require.

3. and/or the list keeps the last values and I end up with a mess!.

4. All of the above.

The reality is I don't know what I am doing!

Filemaker programming is only a part time venture for me, and I have developed some useful solutions in the past, but this has got me beat!

Just to re-cap: I would like the drop down list to show the next 14 days in format: ie: "Thu, 16 Feb 2006" and update automatically and never show past dates, only today and the next 13days...

This is the main part of the scheduler, the rest I think I'll be ok with.

Further direction would be appreciated.

ps. sorry if this is a bit vague.

Cheers.

[comment]

No, you're not doing anything wrong. Seems today is the day my mistakes are catching up with me...

This won't work with a value list, because:

1. a value list must be sorted alphabetically, which is not what you need here;

2. a value list must be based on a stored field, while you need an unstored calculation;

3. a value list is used for entry into the field, and "Thu, 16 Feb 2006" is not a valid entry into a date field.

So you must use another method, a bit more elaborate one, to achieve this. See the attached (the files are in v.4 - convert them together).

dates.zip