Is there any way to get day-of-week for Dataview?

mitchmeister · February 4, 2022, 12:57am

What I’m trying to do

I’m trying to format a date-based inline metadata field as the day of the week (ie. Monday, Tuesday etc) as a column in a Dataview.

At the moment I am just using

default(dodate, date(eow) + dur(1 d)).day as  Day

Is there any way of doing this?

mnvwvnm · February 4, 2022, 1:12am

You can try this:

dateformat(default(dodate, date(eow) + dur(1 d)), "cccc") as "day of the week"

But you want only the day of the week?

mitchmeister · February 4, 2022, 1:15am

perfect! Thank you so much . Do you know where are the dateformat strings are documented?

mnvwvnm · February 4, 2022, 1:16am

Dataview uses luxon/iso format

github.com

moment/luxon/blob/master/docs/formatting.md

# Formatting

This section covers creating strings to represent a DateTime. There are three types of formatting capabilities:

1.  Technical formats like ISO 8601 and RFC 2822
2.  Internationalizable human-readable formats
3.  Token-based formatting

## Technical formats (strings for computers)

### ISO 8601

[ISO 8601](https://en.wikipedia.org/wiki/ISO_8601) is the most widely used set of string formats for dates and times. Luxon can _parse_ a wide range of them, but provides direct support for formatting only a few of them:

```js
dt.toISO(); //=> '2017-04-20T11:32:00.000-04:00'
dt.toISODate(); //=> '2017-04-20'
dt.toISOWeekDate(); //=> '2017-W17-7'
dt.toISOTime(); //=> '11:32:00.000-04:00'
```

This file has been truncated. show original

mitchmeister · February 4, 2022, 1:19am

Thanks again so much; I’ve spent hours looking for a solution to this.

mnvwvnm · February 4, 2022, 1:22am

Unfortunately dataview documentation has many faults. dateformat()isn’t there.

EricG · February 4, 2022, 6:16am

Interesting. So do you guess what the code might or something else?

mnvwvnm · February 4, 2022, 2:40pm

I’m following other sources of information: releases changelogs, discord obsidian channel, etc. Not any magic skill!

system · February 5, 2022, 2:40pm

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.