I need to keep columns in two time zones in the analysis.
In the old experience, I could do this when I use this formula in the dataset:
parseDate(formatDate(PeriodStartUTC,‘yyyy-MM-dd HH:mm:ss’,‘Europe/Berlin’),‘yyyy-MM-dd HH:mm:ss’).
In the new experience this formula does not change the time zone and we end up with two columns with equal values.
Is there another formula that can be used
Hi @Mike34 good to see you back in the community!
As per my understanding, there doesn’t appear to be a direct calculated field formula in the new data prep experience that handles timezone conversion the way the old one did. A potential work around you can try is manually add the hour offset. For example, addDateTime(2, “HH”, {PeriodStartUTC}) for CET (+2) or addDateTime(1, “HH”, {PeriodStartUTC}) for UTC+1. This way, you can still have the different time zones, but you would just need to do it manually.
I also attached the official AWS documentation for customizing date and time values, in case it can provide any further assistance.
Hope this helps!
Hi @Mike34,
Hope everything is well with you! Just checking back in since this thread hasn’t received a response in a while. Was the reply helpful to you or were you able to find a solution yourself in the meantime? Please help the community by marking this answer as “Solution” or following up in general within the next 3 business days!
Hi @Mike34,
Since I haven’t received any further updates from you, I’ll treat this inquiry as complete at this time. Please feel free to create a new post if you have more questions.
Thank you!