Behaviour of Date Criteria

When are the dates calculated?

Dates are calculated when the export job is added to the queue for processing, not when the job is actually processed.

For example, you may run an export at 11:12:00 but the job isn't processed until 11:30:00 - due to the number of jobs ahead of it in the queue. When the job is processed by the queue, the date and time criteria is calculated from 11:12:00 and not 11:30:00.

Same day

Same day will include user forms from 00:00:00 on the current day up until the time the export job is processed by the queue.

For example, if the job is requested at 13:30:00 but not processed until 14:00:00, all submissions matching the export criteria for the current day up to 14:00:00 will be included.

Same week

Same week will include user forms from 00:00:00 on the Monday of the current week up until the time the export job is processed by the queue.

For example, if the job is processed by the queue at 14:30:00 on a Thursday, all submissions matching the export criteria from 00:00:00 on the previous Monday until 14:30:00 on Thursday will be included.

Same month

Same month will include user forms from 00:00:00 on the first day of the current month up until the date and time the export job is processed by the queue.

For example, if the job is processed by the queue at 14:30:00 on the 16th January, all submissions matching the export criteria from 00:00:00 1st January until 14:30:00 16th January will be included.

Previous day

Previous day will include user forms for the full 24 hours of the day previous to the current day.

For example, if the job is requested at 14:30:00, all submissions matching the export criteria for the previous day will be included.

Previous week

Previous week will include user forms from 00:00:00 on the Monday of the previous week up until (but not including) 00:00:00 on the Monday of the current week.

For example, if the job is requested at 14:30:00 on a Thursday, all submissions matching the export criteria from 00:00:00 on the Monday of the previous week until (but not including) 00:00:00 on Monday of the current week will be included.

Previous month

Previous month will include user forms from 00:00:00 on the first day of the previous month up until (but not including) 00:00:00 on the first day of the current month.

For example, if the job is requested at 14:30:00 on the 6th February, all submissions matching the export criteria from 00:00:00 1st January until (but not including) 00:00:00 1st February will be included.

Last 24 hours

Last 24 hours will include user forms 24 hours prior to the current date and time when the export is requested.

For example, if the job is requested at 14:00:00 on Friday, all submissions matching the export criteria from 14:00:00 Thursday until 14:00:00 Friday will be included.

Last 7 days

Last 7 days will include user forms from the previous 7 days before the current date when the export is requested.

For example, if the job is requested at 14:30:00 on Thursday 16th, all submissions matching the export criteria from 14:30:00 Thursday 9th until 14:30:00 Wednesday 15th will be included.

Last 30 days

Last 30 days will include user forms from the previous 30 days before the current date when the export is requested.

For example, if the job is requested at 14:30:00 on 12th February, all submissions matching the export criteria from 14:30:00 13th January until 14:30:00 12th February will be included.

Before & After

Specify the exact date and time to use. The data file will include user forms between these dates inclusive.

results matching ""

    No results matching ""