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 (4337202)

Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Return

Feedback Submitted

Did this article solve an issue for you?

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 33472.
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

This has been resolved in version 8.2 of Identity Manager. There is no hotfix for this issue.
Change Request

33472

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Request 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 (4337202)

Title

Description

Cause

Resolution

Change Request

Leave a Comment