How to display the days of the week?

olivia · Post time 2020-5-12 15:15:17

hi, I want to calculate the days of the week from a data column that stores date information.

thank you

Best Answer

HI： In Finereport，you can use formula WEEKDAY to get the date and returns the number of weeks More details you can refer to this document：https:// ...

Seigann
Published on2020-07-31
Detailed Answer>>

jaroet · Post time 2020-7-30 22:30:38

In postgresql you can use :

extract(dow from datefield) as day_of_week

That gets you the number between 0 and 6 (0=sunday). If that is what you need?

Sybil · Post time 2020-7-31 10:36:59

HI：

In Finereport，you can use formula WEEKDAY to get the date and returns the number of weeks
More details you can refer to this document：https://help.finereport.com/doc-view-819.html#49

[solved] How to display the days of the week?

Best Answer

Recommends2