Skip to main content

IF or SWITCH? If the date is 6/29/2023 then it would return "Th" for Thursday

  • March 3, 2023
  • 4 replies
  • 36 views
E
Forum|alt.badge.img+1

Hi,

I have a few dates and want to generate the day of the week initial based on the date in a column.

If the date is 6/29/2023, then it would return Th.

I've tried If and Switch, but my formulas are definitely wrong I think because it is related to a date. Ideas?

4 replies

Databaser
Forum|alt.badge.img+25
  • Databaser
  • Brainy
  • March 3, 2023

Hi @eveningmeadow 

You can use a formula for this: DATETIME_FORMAT(your date field, 'format specifier') . 

Jan - Databaser
E
Forum|alt.badge.img+1
  • eveningmeadow
  • Author
  • New Participant
  • March 3, 2023

Hi @eveningmeadow 

You can use a formula for this: DATETIME_FORMAT(your date field, 'format specifier') . 


Ok, that is not working for me. 

DATETIME_FORMAT(SWITCH(
 {Start},
   06/30/2023, "F",
   06/29/2023, "Th',
   06/28/2023, 'W',
   06/27/2023, 'T',
   06/28/2023, 'M',
   07/01/2023, 'S'
))
E
Forum|alt.badge.img+1
  • eveningmeadow
  • Author
  • New Participant
  • March 3, 2023

Hi @eveningmeadow 

You can use a formula for this: DATETIME_FORMAT(your date field, 'format specifier') . 


I tried this too 

IF({Start} = DATETIME_FORMAT{06/30/2023}, "F")
AirOps
Forum|alt.badge.img+10
  • AirOps
  • Participating Frequently
  • March 3, 2023

I tried this too 

IF({Start} = DATETIME_FORMAT{06/30/2023}, "F")

To build on @Databaser's suggestion try this: 

DATETIME_FORMAT([your date field], "dd")

This returns the following abbreviations: 

The issue you are encountering is because you need to pass the formula one of the supported specifiers listed on this page: https://support.airtable.com/docs/supported-format-specifiers-for-datetime-format 

If you need just the first letter of the abbreviation except on tuesdays/thursdays you could write: 

 

IF(OR(DATETIME_FORMAT(Date, "dd") = "Tu", DATETIME_FORMAT(Date, "dd") = "Th"), DATETIME_FORMAT(Date, "dd"), LEFT(DATETIME_FORMAT(Date, "dd"), 1))

 

I hope this helps!

 

 

 

AirOps Consulting | Course: Airtable Mastery
Terms & ConditionsAccessibility statement