XERO querydb: Difference between revisions

From Data Islands
(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)