date calc needed

[maui]

How to write this calc....

if = 3, result should display upcoming 2 weeks of Saturday's, Friday's, Thursday's in date format.

Example for the upcoming 2 weeks. Should return

11/25/2010

11/26/2010

11/27/2010

12/02/2010

12/03/2010

12/04/2010

Thank you!

maui

[Matthew F]

Do you really want multiple dates all listed in a single field? If so that would need to be a text field, not a date field. To do this with a calculation would be difficult. You will not bea able to use the date functions and formatting features built-in to Filemaker.

Much easier would be to use a script uses a loop. It would loop over the upcoming 14 days and add the date to your field on an extra line if it meets your critieria (Thu, Fri, or Sat).

[maui]

Thanks mfero!

could you tell me what the loop script would look like?

Thanks again,

maui