Separate Date and Time Columns
O
Oyster Clownfish
As a SalesMsg user, I'd like to be able to import a separate column for dates and times/timestamps.
Use case: showing shift times in the contact import page.
Created by Susie Trent
Chris Brisson
Hey Oyster Clownfish, thanks for your feedback! Following up on this:
- What specific format do you currently use for importing date and time data?
- Are there any specific time zones that need to be considered during import?
- How frequently do you need to import date and time data for shifts?
O
Oyster Clownfish
Hi Chris,
Thanks for working with me on this!
1. Currently, I use the format below; I include both the date and the time in one column:
“Tuesday, November 11, 5:45 AM”
However, I’ve also tried to separate time and date into two columns in my following importing attempts:
“Tuesday, November 11” “5:45 AM”
2. No, as for my purposes, all workers are operating within the same time zone.
3. We import this data Monday through Friday, every week.