• Multiple timezone issue

    By Rob Breault 2 decades ago

    Got another interesting issue since we work with alot of clients on the "left" coast, looking at the email "conversation" in the VIC Journal "All Mail" view (MailbyOrganization) the order of the messages is all wrong…



    Simplified View: (there were a total of 10 or so emails but this shows how it looks)

    12/08/2004 12:03:41 PM - My response (2)

    12/08/2004 02:28:06 PM - His response (3)

    12/08/2004 11:25:37 AM - Original email received (1)



    Here is my fix:

    1 - Delete the SortedDate (hidden) column

    2 - Change the Date column to sorted, descending… and change the column formula to:

    @If(@IsTime(DeliveredDate); DeliveredDate; @IsTime(PostedDate); PostedDate; @Created)