Hi there,I'm trying to build automations for updated a multiple select field. The records in my table all have a "last updated date" field, which obviously changes every time a record is updated. There are two scenarios I am trying to solve for:1. Wh...
Hi there. I’m trying to create an interface designer graph element that has year on the x-axis. The data I would like to pull from for the x-axis is a formula field formatted as a date, grouped by year. Every time I’ve tried to create an interface de...
I’ve imported some data into Airtable which includes a column with dates, but as a text string. I would like to be able to sort, filter and group this data by date, so I need to figure out a way to turn that text string into a date field type. I crea...
That totally worked! Thank you so much!
Including my formula here for any future people :slightly_smiling_face:
IF({Deal Date (PB)},DATETIME_PARSE({Deal Date (PB)},“DD-MMM-YYYY”))
Also to note, the solution I found of copying + pasting the formula output into a date field type column won’t work for me long term because the data feeding into the formula will change periodically, so I would like the Interface graph to change wit...
Wow @Kamille_Parks, you just made my whole day, week, month, year! I’ve been trying to figure this out for so long and I just had to tweak my formula slightly for the Formatting to work / be an option.
THANK YOU SO MUCH! Problem solved :slightly_smi...
@Kamille_Parks thanks for your quick response! Got it on not having to use the DATETIME_FORMAT. However, the third column isn’t extraneous because I can’t sort, filter or group using a formula field type, so I can’t exactly use the results of the DAT...
@Caitlin_Warlick-Shor - I was wondering if you could explain your solution further? I’ve been able to extract my date information using a formula, but can’t figure out how to turn the results of that formula into a date field type as you described in...
