Drop down list with date

[malagasy]

Hi,

I have a drop down list in my invoice section that allows me to select the day the service will be provided. The drop down list takes the data from a field called Date and i would like the drop down list to only show the dates that has yet to come.

For example, I have 52 entries in this date field which are the 52 saturdays of the year. we are 23rd feb so i would like the drop down list to show only the saturdays to be coming and not the ones that already happened...

Is there a way of doing this ? I'm quite unexperienced so i would appreciate an English version of the things to do ! :-)

Regards.

[RT]

i am not experienced enough to tell you what to do but you may be interested in this thread. it may point you in the right direction.

http://fmforums.com/forum/showtopic.php?tid/179235/

[RodSierra]

If you already have the dates in a field, I think that's how I understand it create a calc field:

Case ( Date ≥ Get ( CurrentDate ) ; Date ; "")

Base your value list off that field.

Rod

[Genx]

This is a potential way of displaying only future saturdays, though i'm not sure what you have against the calendar.

dateExample.zip

Edited February 23, 2007 by Guest

[malagasy]

I like your solution Genx but unfortunately, it doesn't seem to be working for a portal.

Sorry, I should have been more precised ! Indeed, my services are given over 5 or 10 saturdays in a row.

1 / In the drop list that will be in the portal, I only want the upcoming saturdays.

2/ Also, is there a way so the portal automatically enter the 4 or 9 other saturdays by itself in the portal ?

Cheers.

[mr_vodka]

How about something like this.

dateExample2.zip

[malagasy]

This exemple given by Mr_vodka seems to be good for automatically enter data in the portal but can't do much about the drop list date problem

[mr_vodka]

What exactly is the issue. the drop down list displays what you asked for. It displays 52 saturday dates.

[malagasy]

I'd like the drop down list to only show the UPCOMING saturdays, not the ones that already have gone.

[mr_vodka]

I still dont understand. The drop down only displays the saturdays that begin with this coming saturday Mar 03, 3007. There is no past saturdays...

[malagasy]

of course it displays the upcoming saturdays but it won't be the case in the weeks coming.

I should have been clearer, sorry, i'm trying to have something dynamic.

ie: let's say we are 26th march, i don't want the previous weeks to appear...son on and so forth.

Thanks for your help John and the others

[Genx]

Why do you think it doesn't work in a portal?

dateExample.zip

[mr_vodka]

This sunday (mar 4th), the drop down list will change so that it will only show values starting from Mar 10th, 17th, 24th, etc.

[malagasy]

Genx > this solution is working however when I try to apply it to my database, the drop list is empty. Can you explain what I should be looking at in this case and why it doesn't work.

Thanks