Separate Date and Time Columns | 💡 Feature Requests

Separate Date and Time Columns

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?

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.

Chris Brisson

Oyster Clownfish: When you import date or date & time field, it will need to be in this format in your CSV, not in a format like "Tuesday, November 11"
2025-11-12 6:30 PM
You can see the accepted formats for imports here: 
https://help.salesmessage.com/en/articles/3192286-import-your-contacts
We do have Date and Date & Time fields which you can import.

Photo Viewer

Photo Viewer