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!

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

 

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.

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.

Hi

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