Problem with Date Format

Issue:

After upgrading Adeptia to version 6.9, the Date Format function in the Data Mapper is no longer working correctly. Example: date-format ('01: 00: 00 ',' hh: mm: ss ',' hhmmss ') gives 010000 as expected, while date-format (00:00:00,' hh: mm: ss ',' hhmmss') gives empty as a result.

Cause:

From Adeptia's latest upgrade v6.9, we have adopted the standards of "HH" instead of "hh" as Hour format.

Solution:

Use "HH" as hour format instead of "hh" to get the correct date.