If a time of 0:00 is currently entered in a column with DataType = 5 (Date), then the date is interpreted as only the date, there is no UTC conversion (327336)

Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

If a time of 0:00 is currently entered in a column with DataType = 5 (Date), then the date is interpreted as only the date, there is no UTC conversion
Description

If a time of 0:00 is currently entered in a column with DataType = 5 (Date) (meaning midnight), then the date is interpreted as only the date, there is no UTC conversion.
Cause

Product defect
Resolution

WORKAROUND:
Create a value template for the column in question based on the value template for PWO.ValidFrom
Dim dtValidFrom As DateTime = $ValidFrom:Date$
If ( Not DbVal.IsEmpty(dtValidFrom, ValType.Date) AndAlso dtValidFrom.TimeOfDay = TimeSpan.Zero) Then
'to interpret as UTC a time is necessary
Value = dtValidFrom.AddTicks(1)
End If
STATUS:
Waiting for a fix in a future release of Identity Manager.
Change Request

33472

Feedback submitted.

Was this article helpful?

[Select Rating]

Request or Create a KB Article »

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

If a time of 0:00 is currently entered in a column with DataType = 5 (Date), then the date is interpreted as only the date, there is no UTC conversion (327336)

Title

Description

Cause

Resolution

Change Request

Leave a Comment