Ok, I give up. I've searched and attempted many different options for resolving my date/timestamp issue without success. I have the following value:
Upon extracting the date value, no matter what syntax I have employed (including the Date, Date#, Timestamp, Floor, etc. functions in various syntax positions), the date is returned as Sep 1 instead of Aug 31. What I know about this field is that it is supposed to contain the date and time CST. I would greatly appreciate assistance with the following questions.
1. How best can I most efficiently extract the date 08/31/2018 as [Trans Date]?
2. How best can I most efficiently extract the seconds, 48, as [Trans Seconds]?
In your example, the 5 hours are added to derive UTC time which makes it the next day. You can convert using the ConvertTolocalTime() function as Rahul suggested. Or if you really only want the date portion, use just the date portion of the string when you load it.
Date(Date#(left(myfield, 10), 'YYYY-MM-DD')) as TranDate