Softr DB formula query for date format

Ask the community
1

AI has written a formula for me (same as I would):

DATETIME_FORMAT({Booking Date}, "dddd")

but the result is always an empty formula field (the Booking Date field contains valid dates on every row). What else can I try (to see day of week)?

2

@Jjenglert I do confirm this strange behaviour, bug here :thinking:

3

@matthieu_chateau and @MarkSchofield what would you like to get with “dddd” ?

4

thanks @artur

5

This is what happens in Airtable when using the formula DATETIME_FORMAT({due date}, "dddd") - formula field “Day of the Week”

Capture d’écran 2025-11-11 083810
Capture d’écran 2025-11-11 083810845×690 24.2 KB

1 Like
6

pls try DATETIME_FORMAT({due date}, "EEEE")

2 Likes
7

"EEE" is abbreviated (Mon, Tues)

"EEEE" is full (Monday, Tuesday)

To note that Softr’s “help write formula with AI” will need to be updated to reflect this syntax in place of “dddd”.

Thanks @artur

8

Going to instruct AI to be smarter about those…

1 Like