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

1 #
olivia
Post time 2020-5-12 15:15:17 | Show the author posts only |Read mode Print Prev. thread Next thread
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:// ...
Reply

Use magic Report

Recommends2

Jump to specified page
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
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
You have to log in before you can reply Login | Register


0following

0fans

4Posts

Post