Category / Section
Dynamic Date and Time Formatting in Bold Reports
Published:
Updated:
Creating reports involves presenting date and time information in a clear and understandable manner. Users often have varied preferences for how they want this information displayed. This knowledge base article provides guidance on dynamically changing the date and time format using Parameter in Bold Reports, catering to individual user requirements.
Steps to Change the Date-Time Format.
- Open the report designer, navigate to the Data Configuration panel, and select the Parameter icon to open the PARAMETERS panel. Click on NEW PARAMETER.
- Provide a name and prompt for the parameter, then click Save to proceed.
- Drag and drop a TextBox into your report, Right-click inside the TextBox, select Expression and enter the Date Field Value. Then click OK.
- Select the TextBox, in the properties panel. Click on the format icon, then select Expression to open the expression dialog.
- In the expression dialog, enter the parameter expression. Then click OK.
- Preview your report to see the date format, which will be displayed based on the value entered in the parameter. For example:
MM/dd/yyyy
dd/MM/yyyy
Please download a sample report using the link below.
By following these steps, you can customize date formats according to user preferences in Bold Reports.