Daylight Savings Time handling enhancement?

Follow

Permanently deleted user

• March 24, 2017 16:05

 

Like many customers, we are having issues dealing with Daylight savings time and parsing this information.  While we expect data to come in properly, only the DATE function goes a step further in its validation - is it a legitimate time/date.

While its understandable that the tool is just doing its job, we know that data coming in can use different timezones.  It seems best practice for everyone to choose UTC as their default timezone.

1. Can we have an enhancement to allow us to set timezone (ASDATE) within the import job rather than just being system wide? [or if it exists, to highlight it]

2. Can we have an enhancement within Import to kick out those entries which do not validate so they could be imported during another action?

Folks can also refer to:

https://datameer.zendesk.com/hc/en-us/community/posts/255641946-Cannot-parse-a-date-in-another-time-zone

 

0

• 

  Gido

  • March 24, 2017 16:21

  Hello Jeff,

  Thanks for your enhancement requests. I will forward them to our engineering. 

  Additionally I like to propose another approach to Work with Datetime Values from Different Time Zones. 

   

   

  0

  Comment actions Permalink

Please sign in to leave a comment.