XERO querydb: Difference between revisions
From Data Islands
WikiSysopdi (talk | contribs) No edit summary |
WikiSysopdi (talk | contribs) No edit summary |
||
| Line 13: | Line 13: | ||
Date Fields in queries | Date Fields in queries | ||
- DateTime(YYYY, MM, DD) | |||
EG | |||
- DateTime(2022, 01, 01) | - DateTime(2022, 01, 01) | ||
Revision as of 16:05, 16 August 2022
repeatinginvoices
Fields:
- Schedule
-- StartDate (Schedule.StartDate)
Date Fields in queries
- DateTime(YYYY, MM, DD)
EG
- DateTime(2022, 01, 01)
Example
querydb repeatinginvoices Schedule.StartDate >= DateTime(2022, 01, 01) AND Schedule.StartDate <= DateTime(2022, 12, 31)
querydb invoices Date >= DateTime(2022, 01, 01) AND Date <= DateTime(2022, 01, 31)
To get the xero invoice pdf files
querydb invoices "Date >= DateTime(2022, 01, 01) AND Date <= DateTime(2022, 01, 31)" FILES
