Forum Discussion
Date sorting
Hi, I've posted this quesiton previously, but still can't seem to solve the problem. I have a list of Facebook posts, which need to be ordered by the post date/time, but it is still orderin...
How about a calendar table consisting of 2 columns: US Date, AU Date
Link the facebook table to the calendar table using the US Date. It will probably be a many:1 relationship.
Use the US date for all calculations but use the AU date in the visualisation. This should allow you to use any date format (or even colours if that's your thing) in the visualisation.