How the Advanced Date Component Determines Date and Time

This topic explains how aEDI determines the date and time on reports.

Date options available depends on the report selected. Regardless of the report the Advanced Date component only passes the date to the backend to retrieve data and not the time. Time considered for a day is 12 AM to 11:59 PM. This avoids any conflicts that can result due to time zone difference and also to fetch data for the complete day.

Date/Time Description
Today
  • Date considered for fetching data is today's date. For example if today's date is September 12th, then date considered is 09/12/2022 12:00 AM to 09/12/2022 11:59 PM. Filter ToolTip will display 'Start Date: 09/12/2022 ' | 'End Date: 09/12/2022'
Hour
  • Time is shown in 12 hour format.
  • Hours considered for fetching data are the last X hours.

    For example if current time is 2:30 PM, Hours selected is 5 hours, User Time Zone is IST, then time considered is 09:30 AM IST to 12:30 PM IST.

    Filter ToolTip will display 'Start Time: 09:30 AM IST' | 'End Time: 12:30 PM IST'.
Day
  • Date considered for fetching data is last X days + Today.

    For example if today's date is September 12th, Days selected is 7 days, then date considered is 09/05/2022 12:00 AM to 09/11/2022 11:59 PM + today which will be 09/12/2022 12:00 AM to 09/12/2022 11:59 PM.

    Filter ToolTip will display 'Start Date: 09/05/2022 ' | 'End Date: 09/12/2022'
Week
  • Date considered for fetching data is last X weeks + Today.

    For example if today's date is September 12th, Weeks selected is 2 weeks, then date considered is 08/29/2022 12:00 AM to 09/11/2022 11:59 PM + today which will be 09/12/2022 12:00 AM to 09/12/2022 11:59 PM.

    Filter ToolTip will display 'Start Date: 08/29/2022 ' | 'End Date: 09/12/2022'
Month
  • Date considered for fetching data is last X months starting from today.

    For example if today's date is September 12th, , Months selected is 3 months, then date considered is 06/12/2022 12:00 AM to 09/12/2022 11:59 PM.

    Filter ToolTip will display 'Start Date: 06/12/2022 ' | 'End Date: 09/12/2022'
Year
  • Date considered for fetching data is the complete year.

    For example, if year selected is 2021, then date considered is 01/31/2021 12:00 AM to 12/31/2021 11:59 PM.

    if year selected is 2022, then date considered is 01/31/2022 12:00 AM to 12/31/2022 11:59 PM.

    Filter ToolTip will display 'Start Date: 01/31/2022' | 'End Date: 12/31/2022'.
Date Range Date considered for fetching data will be the selected range. For example if date range selected is 09/01/2022 to 09/12/2022, data will be fetched for 09/01/2022 12:00 AM to 09/12/2022 11:59 PM.

Filter ToolTip will display 'Start Date: 09/01/2022 ' | 'End Date: 09/12/2022'.