Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Primary Formula w/ Concatenate and Date

613 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Dan_Mitchell
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m using Airtable to track email & social marketing campaigns for multiple sites/lists.

I’m using a formula in the primary field of a Multi-Channel Campaign Tracker that grabs the date from a SendDate column but it is pulling the time as well…the date column is set up with no time.

This is my formula: CONCATENATE(SITE&"-"&Channel&"-"&{Email #}&"-" & SendDate)

And this is what I get: SITE-EM-2-2018-12-28T00:00:00.000Z

How do I not get the time bit appended? Like this: SITE-EM-2-2018-12-28

Thanks in advance…

1 Reply 1

Just an FYI, you can use the & symbol in lieu of the CONCATENATE() function. So you should be able to do this:

SITE &
"-" &
Channel &
"-" &
{Email #} &
"-" &
DATETIME_FORMAT(SendDate, 'YYYY-M-D')

And if you prefer a different date format, you have a plethora of options detailed here:

5f73751092c6afb3485d0dfe997b3809227f5002.png

Supported format specifiers for DATETIME_FORMAT

The DATETIME_FORMAT function will allow you to reformat the data from the date-type field into a string of your specifications. This is written in the form "DATETIME_FORMAT(Datetime, 'format s...