Datetime Filter

Select DateTime Condition

• Select by Minutes

• Select Specific Date

• From Today

• Until Today

• Before

• After

---

Specify the display format of the date-time column.

When data is loaded, it will be displayed in the table on the left. Since custom date-time formats may vary, you need to select the format shown on the left in order to use the date-time filter.

For example, if the date-time format displayed in the column is 2023. 12. 31. 13:12:45, click the date-time icon and select the matching format from the dropdown. Choose the one that looks identical from the list of pre-defined date-time formats.

If none of the predefined formats match your date-time format, you can also enter it manually. For instance: If the column format is 2024-1-11 PM 8:55, enter the format as: yyyy-M-d b H:mm

The method of selecting a date-time format is the same as how you change the data format. For more details, refer to Format Change – Date-Time.

In date-time formats, there should be no space or only one space between elements. For example, formats like 2023. 01. 01 13:11:11 (with multiple spaces in the middle) may cause errors.

✔️ Correct: 2023. 01. 01 13:11:11 ❌ Incorrect: 2023. 01. 01 13:11:11 (multiple spaces)

When using date-time filters, it's important to note the difference between H and HH in time formatting:

• H → represents hours without a leading zero (e.g., 9)

• HH → represents hours with a leading zero (e.g., 09)

Examples:

• 2024-01-23 9:26 → Use format: yyyy-MM-dd H:mm

• 2024-01-23 09:26 → Use format: yyyy-MM-dd HH:mm

Tip: If your hour value includes a leading zero (e.g., 09), always use HH to avoid errors.