# Extracting the “day of the week” from the date
**URL:** https://community.glideapps.com/t/extracting-the-day-of-the-week-from-the-date/38100
**Category:** Ask for Help
**Created:** [February 4, 2022, 1:48am UTC](https://community.glideapps.com/t/extracting-the-day-of-the-week-from-the-date/38100 "2022-02-04T01:48:03Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [February 4, 2022, 1:48am UTC](https://community.glideapps.com/t/extracting-the-day-of-the-week-from-the-date/38100/1 "2022-02-04T01:48:03Z")
Hello, i am using now the Experimental Code from this thread below:
> [@Extracting the "day of the week" from the date](https://community.glideapps.com/t/extracting-the-day-of-the-week-from-the-date/30189/15):
>
> If you’re talking about @gvalero’s code, use the link below in your Experimental Code. I adapted it to my Replit. https://get-weekday-from-time.thinhdinh.repl.co
But turn up Monday for 5 February 2022. Suppose to be Saturday.
I believe its read as 2 May 2022 instead of 5 February 2022.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 4, 2022, 2:07am UTC](https://community.glideapps.com/t/extracting-the-day-of-the-week-from-the-date/38100/2 "2022-02-04T02:07:52Z")
The date plugins are buggy. I don’t recommend using them.
You can get the Weekday name from a date without using any plugins as follows:
- Create a lookup column that lists the days of the week, beginning from Sunday. This column can be anywhere, but I usually have it in a dedicated “Lookup” table
- Use a Math column to get the Weekday index number of the date in question: `Weekday(Date)-1`
- Use a Single Value column to take the above index “from start” of your weekday lookup column.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 4, 2022, 4:22am UTC](https://community.glideapps.com/t/extracting-the-day-of-the-week-from-the-date/38100/3 "2022-02-04T04:22:03Z")
> [@Darren\_Murphy](#):
>
> The date plugins are buggy. I don’t recommend using them.
I agree. This puts me in a lot of trouble recently, especially with countries that use dd/mm/yyyy.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [February 4, 2022, 4:22am UTC](https://community.glideapps.com/t/extracting-the-day-of-the-week-from-the-date/38100/4 "2022-02-04T04:22:29Z")
Right!
As @Darren_Murphy wrote, most plugins have bugs working with dates (and if the date format is not US, the problem is worse).
Here my tests playing with some dates
Using the Glide’s **JavaScript plugin** , it has serious problems working with days \>12 due to it confuses days with months (DD/MM/YYYY).
Instead, the **Format Date plugin** works perfectly and can be used without problem (so far).
Saludos a todos!
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [February 4, 2022, 4:28am UTC](https://community.glideapps.com/t/extracting-the-day-of-the-week-from-the-date/38100/5 "2022-02-04T04:28:08Z")
> [@gvalero](#):
>
> Instead, the **Format Date plugin** works perfectly and can be used without problem.
Not sure I’d agree with that. I’ve found the Format Date plugin to be one of the worst of the lot.
I just don’t trust _any_ of them, and I don’t use them. Mark has said that they will fix them, hopefully soon…
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [February 4, 2022, 4:32am UTC](https://community.glideapps.com/t/extracting-the-day-of-the-week-from-the-date/38100/6 "2022-02-04T04:32:32Z")
Well, at least the Format _ **cccc** _ works fine using DD/MM/YYYY format 😜
Bye Darren!
---
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [February 4, 2022, 5:31am UTC](https://community.glideapps.com/t/extracting-the-day-of-the-week-from-the-date/38100/7 "2022-02-04T05:31:26Z")
I dont think so.
I have problem, after i found out it because i am using the cccc one.
You can see threads below.
> [@Not Tally with the Row Details](https://community.glideapps.com/t/not-tally-with-the-row-details/38101):
>
> Hi, I am not sure what happen but i believe that is the correct row reflection of the view. But the detail of the row not turning up right way. can you tell me why and how to overcome this problem ? eg: normal hour should be 4 , but it turns 8 I also try to put the “Day”. The row should be Saturday but it turn up Monday. You can see “Saturday” (the right answer) in view data button on the right.
and i changed to the Darren’s one, then its works after.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [February 4, 2022, 5:47am UTC](https://community.glideapps.com/t/extracting-the-day-of-the-week-from-the-date/38100/8 "2022-02-04T05:47:48Z")
Well, it’s working for me, maybe an improvement was done days ago and some issues were gone.
I changed my Chrome’s regional settings to US and still works fine ( Format Date plugin):
Saludos!
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [February 5, 2022, 5:48am UTC](https://community.glideapps.com/t/extracting-the-day-of-the-week-from-the-date/38100/9 "2022-02-05T05:48:25Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.