Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Phrase

Description

Dynamic update?

Usage

Availability

This Year

Query data for this calendar year. 

Yes

Date with/without Time Component

System wide

Last Year

Query data from the last calendar.

Yes

Date with/without Time Component

System wide

This Year Start

Query data from a specific, single day — the first day of the current calendar year (based on the date the report is run).

Yes

Single date

Not in Guided NLQ

This Year End

Query data from a specific, single day — the last day of the current calendar year (based on the date the report is run).

Yes

Single date

Not in Guided NLQ

This Financial Year Start

Query data from a specific, single day — the first day of the current financial year (based on the date the report is run).

Yes

Single date

Not in Guided NLQ

This Financial Year End

Query data from a specific, single day — the last day of the current financial year (based on the date the report is run).

Yes

Single date

Not in Guided NLQ

Last Year Start

Query data from a specific, single day — the first day of the last calendar year (based on the date the report is run).

Yes

Single date

Not in Guided NLQ

Last Year End

Query data from a specific, single day — the last day of the last calendar year (based on the date the report is run).

Yes

Single date

Not in Guided NLQ

Last Financial Year Start

Query data from a specific, single day — the first day of the last financial year (based on the date the report is run).

Yes

Single date

Not in Guided NLQ

Last Financial Year End

Query data from a specific, single day — the last day of the last financial year (based on the date the report is run).

Yes

Single date

Not in Guided NLQ

This Year to Now

Query data for this year so far, specific to the exact time of day  (based on the time you submit your question).

Yes

Date with Time component

System wide

This Year to Date

Query data for this year so far (based on the date your report is run).

Yes

Date with/without Time Component

System wide

This Financial Year To Date

Query data specifically for the current financial year up to the present date.

Yes

Date with/without Time Component

System wide

This Financial Year

Query data for this financial year (based on the date your report is run). This phrase won’t display if your financial and calendar years are the same.

Yes

Date with/without Time Component

System wide

Last Financial Year

Query data from the last financial year. This phrase won’t display if your financial and calendar years are the same.

Yes

Date with/without Time Component

System wide

2021

Type a four-digit year to query data from that year only. 

No

Date with/without Time Component

NLQ only

Last Year to Date

Query data from the start of last year until the current date one year earlier. 

Yes

Date with/without Time Component

System wide

Last Year Month to Date

Query data from the start of the month one year earlier, to the current date one year earlier.

Yes

Date with/without Time Component

System wide

Special phrases

Phrase

Description

Dynamic update?

Usage

Availability

All Time

We highly recommend you always provide a date with your query to avoid resource overload in returning too much data. However, if you want to see results since your data began you can use this phrase.

NLQ only

...