Choose the date field and enter below expression in the dropdown. it will accept and change the format accordingly.
my sample data is in EST and no hours difference and I just hardcoded EST at the end. conversion needed if the data tracked in the different time zone.
mm/dd/yyyy hh:mm:ss AM/PM "EST"
No comments:
Post a Comment