Forum Discussion
Post ProdigyUTC to AEST
You can use the table and function from my post as illustrated in this video:
Post ProdigyThis is incredible and definitly should be stickied as this is probably the first publically available solution to this major problem.
So:
1: I create a table using enter data for the past few years back and forward as I need for the days when daylight savings change.
2: Create a function in my data table using the Custom Function and link my date table with my Custom Function generated AEST column?
Community ChampionYou can use the table and function from my post as illustrated in this video:
- ElliotP
This should be stickied. This is truly amazing. Thank you so much MarcelBeug; I really do appreciate it. You went above and beyond.
This is the best and only solution I've seen to this problem and there seem to be quite a lot of solution types to this problem but none are able to solve the daylight savings issue.
Thank you so much.
- ElliotP
Would anybody know how to increase the initial UTC convert time dates? They start in 2010 but I was hoping to push them to a little earlier (1990).
The initial conversion looks to be from a created date series
(MarcelBeugif you're about:smileyhappy:)
Can you please share the table and function to copy paste - I can't type the binary file
