Scripting automation incorrect month from date object

Hi all! I’m working on an automation script which needs to get the current date so that it can be formatted for a URL. However, calling the .getMonth() function on a date object returns an incorrect month. I can of course correct for this by adding 1 to each month but would prefer not to.

I’ve created a new script which creates a date and logs the resulting month to demonstrate my issue:

The code:
Code Snippet

The resulting console logs:
Console log

Has anyone encountered this issue before? Thanks!

1 Like

Hi @Sam_Richter,
I believe that getMonth() is zero based value, so January is 0.

1 Like

Thanks @Vivid-Squid I’m going to look more closely at the JS documentation in the future.

This is not an Airtable behaviour; it is how javascript dates work. This is a flaw inherited from Java way back before you were born. :wink:

stackoverflow.com/questions/344380/…

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.