FineReport Community

Title: How to display the days of the week? [Print this page]

Author: olivia    Time: 2020-5-12 15:15
Title: How to display the days of the week?
hi, I want to calculate the days of the week from a data column that stores date information.

thank you

Author: jaroet    Time: 2020-7-30 22:30
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?
Author: Sybil    Time: 2020-7-31 10:36
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




Welcome to FineReport Community (https://community.finereport.com/) Powered by Discuz! X3.2