Prep Flow with MAKEDATETIME is not working as expected with version 2022.3

Issue

A flow with MAKEDATETIME is not working in Tableau Prep Builder 2022.3. The calculation result will be NULL if MAKEDATETIME is used in the calculated field.

Environment

Tableau Prep Builder 2022.3
Tableau Prep Conductor
Tableau Server

Resolution

Use the DATETIME() function instead if not able to upgrade the Tableau Prep Builder version.

DATETIME() returns a datetime given a number, string, or date expression.
Example:
DATETIME(“April 15, 2005 07:59:00”) = April 15, 2005 07:59:00

Cause

The issue is fixed in Prep version 2022.3.3 and 2022.4.1 but not resolved in Tableau Server. Please see Known Issue ID 1472324 for Tableau Server updates.