+5Hello - 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.
Best answer by Mohamed_Swella1
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?
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")
+17Hi @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")
+5Hi @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")
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!
+17Hello 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!
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")
+5No 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")
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?
+17AH! 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?
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")
@Mohamed_Swellam THANK YOU! It worked! Appreciate your help!!
Always my pleasure ! Kindly mark it as Solved :slightly_smiling_face:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.