Feb 22, 2018 02:01 PM
We have a field for Calendar Date. Is there a way to have the day of the week (Monday, Tuesday, etc.) that corresponds to that calendar date autopopulate in another field?
Feb 22, 2018 02:03 PM
The formula below should work (I’m using it currently):
DATETIME_FORMAT({INSERT YOUR DATE FIELD NAME HERE},‘dddd’)
Let me know if not!
Mar 01, 2018 08:27 AM
Hmm, I did something wrong…
Mar 01, 2018 09:26 AM
Hmm, I just retested this in my base and it worked. Try reloading the base or creating a new formula field from scratch and calling it something different (you can change the name later) and see if either of those things help.
If not, maybe contact support@airtable.com because I’m not sure why it’s not working for you.
Example of my most recent test formula vs. yours:
DATETIME_FORMAT({Day},‘dddd’)
DATETIME_FORMAT({Date},‘dddd’)
Mar 01, 2018 09:48 AM
Thanks! I definitely will.
Mar 01, 2018 11:31 AM
Replace the ‘curly quotes’ (like the ones around the words ‘curly quotes’) with straight quotes (’''
’) — just overtype them. You presumably copy-and-pasted the formula from this forum, and the forum software prettifies quotation marks.
Or copy and paste the following, which has been formatted to include the correct form of quote:
DATETIME_FORMAT({Date},'dddd')
Mar 01, 2018 11:43 AM
That did it! THANK YOU SO MUCH!!! It was driving me crazy, lol. Such an easy fix, yes!!
Mar 01, 2018 12:47 PM
Oh wow good to know! Of course it was something so small… :grinning_face_with_sweat:
Mar 01, 2018 01:00 PM
I love an easy fix!! :smiling_face_with_sunglasses:
Mar 01, 2018 03:57 PM
You can put the forum into code mode three different ways; text displayed as ‘code’ doesn’t have ‘prettified’ quotes.
To tag a word
or a phrase
, precede and follow it with a back-tick character (’`
’). Doing so will prevent the conversion of straight quotes into 'curly quotes'
. (On US keyboards, the back-tick is to the left of the [!/1]
key; it’s the unshifted tilde (’~’). On international keyboards it is known as the grave accent and is often found to the left of the Return
key. In such cases it’s usually a dead key, so to enter it as a character one uses the two-stroke sequence of `
+ Spacebar
.)
An entire line of text can be flagged as code by
preceding it with 4 space characters. (Unless it also needs to be
indented, like these examples; in that case it takes 7 spaces.)
Like all code-format methods, it disables 'curly quotes'.
Longer code segments can be preceded and followed by a line containing 3 back-ticks by themselves — like so: ```
Code tagged in such a manner
also retains indentation
and is
formatted in such a way as to
highlight 'language features'
May 05, 2021 07:35 PM
hey everybody, did you guys ever see something like this before? if yes, what could be the reason. all the events are created by someone else except the one shows the same date with a different day. would appreciate if anyone can help me out
May 05, 2021 09:10 PM
Welcome to the Airtable community.
When you use DATETIME_FORMAT
, the formula calculates the date based on GMT, unless you include the SET_TIMEZONE
. When it is 5pm where you live, it is midnight GMT.
Here is an example. The function is documented in the formula field reference, and the available time zones are documented here.
DATETIME_FORMAT(SET_TIMEZONE({Date}, 'America/Los_Angeles'), 'dddd')
May 05, 2021 11:38 PM
great! thank you for a straightaway answer!