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

mitchmeister · 2022-02-04T00:57:44.567Z

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 · 2022-02-04T01:12:30.054Z

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 · 2022-02-04T01:15:17.592Z

mnvwvnm:

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

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

mnvwvnm · 2022-02-04T01:16:43.378Z

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 · 2022-02-04T01:19:19.740Z

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

mnvwvnm · 2022-02-04T01:22:26.152Z

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

EricG · 2022-02-04T06:16:10.527Z

mnvwvnm:

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

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

mnvwvnm · 2022-02-04T14:40:13.889Z

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

system · 2022-02-05T14:40:36.112Z

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