From Month to Month

[Glorifindal]

perhaps someone can help me with the following :

I have a global text field - g_Month - which is used in a relationship. It contains a value list of Month names. There is a button on either side of this field on the layout which is supposed to cycle through the month names -

How do I obtain the previous / next month's name ?

Many thanks in advance,

Kindest Regards

Glorifindal

[bcooney]

It's not clear what you are asking. Are you trying to build this functionality or use it? Are you the developer?

PS: You have ranked yourself as Advanced. Many people confuse this setting with the fact that they are using FM Advanced.

[Søren Dyhr]

It could perhaps be done this way? Provided I have read the sparingly spec's correctly?

--sd

switching.zip

[Glorifindal]

That's exactly what I need - Many thanks Søren - I like this way of doing it indeed

Kindest Regards

Glorifindal

[comment]

It would be a lot easier to calculate the first of the month (as a date) instead of the month's name. This has two advantages: (a) the year is included, and (: bumping a global date up or down a month is rather trivial. The global date field can be formatted to show only the month (or month and year, depending on the purpose).

[Søren Dyhr]

The global date field can be formatted to show only the month (or month and year, depending on the purpose).

I did actually think about those lines, but the valuelist is the catching point... perhaps you can think of a way the dropdown won't show a series of dates instead of the names of the month?

--sd

[comment]

I don't see the need for a value list or a drop-down - in my approach or in yours. But if required, the global could use a drop-down calendar, with auto-correction to the first of month of the selected date.

[Søren Dyhr]

Well then I see something else:

I have a global text field - g_Month - which is used in a relationship. It contains a value list of Month names.

But if required, the global could use a drop-down calendar, with auto-correction to the first of month of the selected date.

Indeed behave, close ranks etc. LOL... but yes it usually how I do it as well. But here are the requirement made!

--sd

Edited April 8, 2010 by Guest

[comment]

Well yes, he did say that - but I don't think it's necessary to have both arrows AND a drop-down with only 12 values. Of course, it's still possible with both methods - but my main point is that basing a relationship on month name alone will lump together records of February 2010, February 2009, etc.

[Søren Dyhr]

Yes that's how I would do it and then use a calc'field to establish the upper range limit. But when did the drop down calender arrive was it by the arrival of fm8 or fm8.5 I could remember Shawn had some templates for fm7:

http://www.spf-15.com/fmExamples/

...his datepicker templates!

--sd

[comment]

I don't remember either, but it doesn't matter - because, as you say, you could use a self-made date picker instead.