Help With Date Formatting in Report

Ignition
1

I am using Ignition 8.1.15.

I have a date parameter that has an experssion of:

dateFormat(“2022-03-07 00:01:00”,“yyyy-MM-dd 00:01:00”)

When I drag this parameter onto the report and give it formatting of MMMM d, yyyy in the properties window and preview the report it does not change anything and shows up as 2022-03-07 00:01:00. Is this a bug or is there something else I need to do to format it correctly?

2

dateFormat() returns a String so the Date Format property is not going to be applied to it. Make sure the parameter is Date type, and then add the expression toDate() around the dateFormat().

image

1 Like
3

Thanks, I appreciate it. Turns out this parameter was mistakingly configured anyway so we ended up creating a new one that both shows up properly in the report and works with our stored procedure. I appreciate the help anyway.

1 Like