Question

4
Replies
766
Views
Close popover
Sesha Harikrishna Kanduri (SeshaHarikrishnaK)
LTI
Senior Software Engineer
LTI
IN
SeshaHarikrishnaK Member since 2014 26 posts
LTI
Posted: July 18, 2017
Last activity: July 20, 2017
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.