Please
Login
for use a quick navigation
Have no account?
Register
Help Doc
Training
Events
Certifications
Plugins
Sign in
|
Register
FineReport Community
›
Forum
›
Questions
›
solved
Return to list
[solved]
How to display the days of the week?
View:
4022
|
Reply:
2
1
#
olivia
Post time 2020-5-12 15:15:17
|
Show the author posts only
|
Read mode
Category
Categories:
Formula & JavaScript
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>>
Share:
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
Favorites
0
Reply
Use magic
Report
Recommends
2
Go to Page No.
Ascending
Descending
Ascending
2
#
jaroet
Post time 2020-7-30 22:30:38
|
Show the author posts only
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?
Reply
my point
Publish
Reply
Support
Not support
Use magic
Report
3
#
Sybil
Post time 2020-7-31 10:36:59
|
Show the author posts only
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
Reply
my point
Publish
Reply
Support
Not support
Use magic
Report
Return to list
Advanced Mode
B
Color
Link
Quote
Code
Smilies
You have to log in before you can reply
Login
|
Register
Reply post
To last page
olivia
Level1
0
following
0
fans
4
Posts
Admin Page
Post
Recommendations
Give full play to the advantages of a unified platform to deeply mine data resources
A Step-by-Step Guide to Learning FineReport from Beginner to Expert!
FineReport Community Guidelines
IDC: FanRuan ranks No.1 in China’s BI market share in H1 2019
FineReport Becomes One of Huawei's First Strategic Partners in 2019
To Top
Return to the list