42 Field grid - what date am I

[Glorifindal]

Hi there,

I'm back to Filemaker after a long break - and have been told to implement a Calendar.

I am using a calculation field for each "Day" - as each field is not so much a date as a list of Date attributes - based on the date - i.e for the 10th of November the multi key list would be:

 

10/11/2012

monthday10

monthnum11

SecondSaturday

 

I did OK (I think) as long as the Calendar was allowed to start on the first grid square (the first field knew that it was referring to the first of the month)

BUT - the boss now wants the 42 day grid - with the first days as well as the last days that are not past of the selected month also being shown.

 

My question is - how do I work out the shift needed - i.e how do I know that the first of November is actually the fifth grid square...?

I suppose each field would start with this shift calculation... but am at a loss to know what the calculation is.

I have tried variations on if( 1st of month selected is NOT a Sunday ; then ... ) but lost

 

Could anyone please help me ? I've been struggling for a while now, my head is splitting, my eyes are red ...

 

many thanks in advance

 

Glorifindal

[doughemi]

I'm not following the requirements in your description, but I think you could start with the DayOfWeek({some date}) function.

[comment]

Hi there,

 

I am using a calculation field for each "Day" - as each field is not so much a date as a list of Date attributes - based on the date - i.e for the 10th of November the multi key list would be:

 

10/11/2012

monthday10

monthnum11

SecondSaturday

 

I am not sure what such multi-key is supposed to accomplish. In any case, 42 day fields + 42 calculated key fields is not a good idea - if only because it will also necessitate defining 42 relationships to your Events table. You should be using a days table with 42 records - see an example here:

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

[Lee Smith]

I think the link is broken, I have reported it to Stephan.

[comment]

So have I:

http://fmforums.com/forum/topic/86836-why-doesnt-this-link-work-and-other-weird-stuff/

[Lee Smith]

Yeah, I read that just after posting here. LOL