Using the Date Time Picker in VDM

Trouble Viewing Images? Right-click on any image and select "Open in new tab" to view a larger version. You can also zoom in using Ctrl + Mouse Wheel for easier readability.

Article Goal

This guide demonstrates how to set up and use the enhanced Date Time Picker (DTP) parameter options in VDM, including configuring parameters as date-only, time-only, or full date-time values.

What Are Date Time Pickers?

Date Time Pickers provide precise input when filtering or querying data based on date, time, or both. By leveraging these options, users can create more flexible and targeted reports.

Why Use Date Time Pickers?

Using the enhanced Date Time Picker ensures:

• A cleaner and more intuitive user input experience
• Improved filtering accuracy
• Better integration with date/time-based data fields
• Consistent visual formatting across the application

Types of Date Time Pickers

VDM supports three Date Time Picker formats:

• Date Picker – Select a calendar date
• Time Picker – Select a time of day
• Date & Time Picker – Select both date and time

Preview Examples

Date Parameter

Time Parameter

Date and Time Parameter

Video Tutorial

Steps to Set Up a Date Time Picker Parameter

Step 1: Open or Create a View

Launch VDM and open an existing view, or create a new one to begin configuring parameters.

Step 2: Add a New Parameter

Navigate to the Parameters tab and click Add Parameter.

Step 3: Configure the Parameter

• Set Type to Date Time Picker
• Set Datatype to DateTime
• Set Date Time Picker Type to either:
  • Date
  • Date and Time
  • Time

Optional: Add a descriptive Name for the Parameter and a Description to clarify its use within the view.

Step 4: Use the Parameter in FSGS

Apply the Date Time Picker parameter to a filter in your FSGS logic.

Tip: You can use the parameter to filter against values such as ShippedDate >= [YourDateTimeParameter].

Step 5: Run the View

Execute the view and select a Date, Time, or Date & Time based on your parameter configuration.

Note: When using the time picker, press Enter after selecting a time to apply it.

Step 6: Verify the Output

Ensure that the returned data matches the selected Date Time criteria.

Example: ShippedDate >= 7/16/1996 10:30:00 AM

Article Summary

This article outlines the configuration and usage of VDM’s enhanced Date Time Picker parameter types. By allowing users to select dates, times, or both, VDM provides greater flexibility for building precise queries and filters based on temporal data. The setup is straightforward and integrates seamlessly with the FSGS panel.