Question

4
Replies
703
Views
SeshaHarikrishnaK Member since 2014 26 posts
LTI
Posted: 3 years ago
Last activity: 3 years 2 months ago
Closed
Solved

Text Datatype to Date Data Type

Hi all,

I have a property of a type text, this should hold the value of selected date. but is getting -1 hr. when found out i understood that it is taking as BST, as the time difference is 1 hr. it is subtracted from the hold date. and it gets the value as 31072017T230000.000, on the UI it is configured as Date/Time in the format of 1/1/01 1:00 AM.

I tried changing the operator id as Time zone : Europe/London and USDefault as Calendar

But the requirement was to show as Date. it returns 31/07/2017 instead of 1/08/2017

***Edited by Moderator: Marissa to update categories***

Data Integration
Moderation Team has archived post
Share this page LinkedIn