Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 22, 2022 06:10 AM
Hello - I am trying to utilize a formula to view a date that is formatted like this Tue Aug 23, 2022 3pm - 3:30pm as 08/23/2022. (I do not need the time range in the final view)
I was trying to do a formula like this: DATETIME_FORMAT(DATETIME_PARSE({Formula},“DDD MMM DD, YYYY”), “MMM-DD-YYYY”) but I am just getting an error in return
Am I wildly off? Any help would be greatly appreciated! I am super new to formulas.
Solved! Go to Solution.
Aug 22, 2022 06:48 AM
Oh sorry bout that! I didn’t notice the “-” in the time :slightly_smiling_face:
This should work
DATETIME_PARSE(LEFT(Formula, FIND("-",Formula)-2), "MMM-DD-YYYY")
Aug 22, 2022 06:25 AM
Hi @Sara_Ophoff ,
Welcome to Airtable Community!
I have tested your formula and the problem is the “Tue” in the start of the text. If you removed it then it works fine.
You can use this instead
DATETIME_PARSE(RIGHT(Formula,LEN(Formula)-4), "MMM-DD-YYYY")
Aug 22, 2022 06:33 AM
Hello Mohamed - thank you for the super quick reply! I was able to get ride of the Tue (thank you for pointing that out), but I am still getting an error on my end.
Not sure why it still won’t spit out the date!
Aug 22, 2022 06:35 AM
No worries Sara , my pleasure!
You got rid of the day name in the Formula already, so you dont need the RIGHT() and LEN() parts. You can just do DATETIME_PARSE(Formula, "MMM-DD-YYYY")
Aug 22, 2022 06:43 AM
AH! Yes, thank you again - ok, getting SO CLOSE @Mohamed_Swellam
Now… it IS giving me a date (YES!), but it’s the wrong date.
It looks like it sending me the MONTH correctly but somehow using the TIME RANGE as the other two data points (DATE and YEAR).
Is there something I could add to the formula to essentially say, don’t look at the time range?
Aug 22, 2022 06:48 AM
Oh sorry bout that! I didn’t notice the “-” in the time :slightly_smiling_face:
This should work
DATETIME_PARSE(LEFT(Formula, FIND("-",Formula)-2), "MMM-DD-YYYY")
Aug 22, 2022 06:58 AM
@Mohamed_Swellam THANK YOU! It worked! Appreciate your help!!
Aug 22, 2022 07:00 AM
Always my pleasure ! Kindly mark it as Solved :slightly_smiling_face: