search

kevinschaich / mintable

🍃 Automate your personal finances – for free, with no ads, and no data collection.
https://kevinschaich.io/mintable/
MIT License
1.54k stars 204 forks source link

Invalid Date!A:undefined' #62

Closed lecoffeeguy closed 4 years ago

lecoffeeguy commented 4 years ago

Hi there,

I'm running into an error that I can't seem to fix :

"spreadsheetId": "1L2v2WbA0NWLzv8L9C76cGVxSSxPU7cxJnN7UsM4yY08", "ranges": [ "Invalid Date!A:undefined" ] } ✖ Error clearing ranges invalid date!a:undefined:

{
  error: 'Error: Invalid range[0]: Unable to parse range: Invalid Date!A:undefined'
}

error Command failed with exit code 1. info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.

Any idea where this is coming from ?

kevinschaich commented 4 years ago

What date format are you using in mintable.config.json? Suspect that may be the issue

lecoffeeguy commented 4 years ago

Thanks Kevin. The error was with the spreadsheet setting. The template was set to United States, whereas my spreadsheet was set to France. The date format is by default different.