Changing the Date Format on Check Reports

Business Central offers built-in date formats, but you may need a format that isn’t provided. There are two ways to change the date format on Mekorma check reports:

• Use Business Central’s vendor card date settings (this is a Business Central-native configuration). This uses the standard DateText format, which is all most users need.
• Use Microsoft Report Builder to swap the DateText field for a DateDate field and then edit the date field’s expression to specify a custom format.
  

The following steps are for option 2:

1. Open the check report in Microsoft Report Builder.

2. Under the Date field, find CheckDateText_CheckRemittanceDetails_gRec and replace it with CheckDateDate_CheckRemittanceDetails_gRec. This changes the date to a raw format so you can apply your own formatting.

3. Right-click the field and select Expression…
   

4. In Set expression for: Value, enter: =Format(First(Fields!CheckDateDate_CheckRemittanceDetails_gRec.Value), “yyyy-MMMM-d”).
   

5. Adjust yyyy-MMMM-d to the desired date format.

6. Click OK.

7. Save the report and upload it back to Business Central as a custom layout.

8. Test your changes before implementing the new check to production.