XERO querydb: Difference between revisions
From Data Islands
WikiSysopdi (talk | contribs) (Created page with " repeatinginvoices Fields: - Schedule -- StartDate (Schedule.StartDate) Date Fields in queries - DateTime(2022, 01, 01) Example querydb repeatinginvoices Schedule.StartDate >= DateTime(2022, 01, 01) AND Schedule.StartDate <= DateTime(2022, 12, 31)") |
(No difference)
|
Revision as of 12:45, 1 July 2022
repeatinginvoices
Fields:
- Schedule
-- StartDate (Schedule.StartDate)
Date Fields in queries
- DateTime(2022, 01, 01)
Example
querydb repeatinginvoices Schedule.StartDate >= DateTime(2022, 01, 01) AND Schedule.StartDate <= DateTime(2022, 12, 31)