Monthly Jump

[Bikeman17]

Hi there,

I want to set a date field that upon a click will jump one month like this example : 11-24-2018 to 12-24-2018 to 01-24-2019 etc...

Thanks in advance!

[comment]

I would use two buttons for this - one for up and one for down - so that you can go back in case you clicked one too many.

Anyway, the action is simply:

Set Field [ YourTable::Datefield ; Date ( Month ( YourTable::Datefield ) + 1 ; Day ( YourTable::Datefield ) ; Year  ( YourTable::Datefield ) ) ]

 

Note however, that bumping a date of January 31st up by a month will return March 3 (or March 2 in a leap year), and so on for all ends of "long" months.  If that's not what you want, see: 
https://fmforums.com/topic/59942-frequency/?tab=comments#comment-284146

 

[Bikeman17]

Okay, let me add more information.

I have Table A where there are 5 records that are used as ongoing monthly entries. These records can be imported in Table B during the next month at any time. In order to save time, the date field must jump by one month. I've set up a loop to update the date field but my issue is December to January.

[comment]

I am afraid you have lost me at this point. I could not understand what you're doing -  and even less why you're doing it. The only thing I can say is that the above method of calculation works across year boundaries.

[Bikeman17]

Hi

My window browser did not display all the calc length you posted. So, it raised confusion on my end. Thanks !