This content is now out of date.

Visit Our Community

Using Current Time in Calculated Fields

I am trying to create a calculated using the Pre-Defined Function Date Difference using the Current Date as the start date and a column that is a datetime in the end date field.

The error I am getting is:

An exception occured: Invalid DateFormat '2016-01-15'. Expected date format is: MM/dd/yyyy. Please check the SQL syntax and try again.

Is there a way to have the current date cast to the MM/dd/yyyy format?

Thanks in advance.