Filter depending on date

[pkrotrollet]

How do I get all sessions/hands played certain dates in the month.
I want to show for example all hands played the 27th, 28th,29th, 30th, or 31th from every month.

[pkrotrollet]

Alternatively: If you guys can help me how to in the session tab can create a new column with "date ie day nr X of the month" (and not year, month and date in the same column as is default)
I think I can find a solution on my own !

[pkrotrollet]

What should I write in "expression" in 'configure statistics" to get "day of the month in number" instead of
holdem_hand_player_statistics.date_played ?

[pkrotrollet]

Instead of Start Time under Sessions I would like to show a column with "day of month" (written in a number)
Can this really be so hard???

[WhiteRider]

EDIT: Are you using PT3 or PT4?
I wrote the following for PT4 - if you want it for PT3 it should be possible in a similar way but the column doesn't exist by default.

There is a built-in column called "date_played_day" which stores the day of the month on which hands were played, and if you create a stat to display that (e.g. duplicate and edit "Date Played" to use that column instead) that will display what you want.

To filter by it you'll need to use a custom filter.
For example go to My Reports and create a new Player report, and add your new stat to it (if you wan to break the report up into rows for each day of the month).
Click the blue Filters link and select Expression Filters, and enter an expression like this:

date_played_day > 26

(To use this filter you don't need to create a stat - you only need that if you want to break up the report into separate rows.)

[pkrotrollet]

Thansk!! I use PT3 - how do I create that column. Sry, im noob..

[pkrotrollet]

anyone?

[WhiteRider]

The simplest way will be to duplicate the column "date_played" and change the "dateextract_date" part to "dateextract_day".
Once you have that column the same things apply - check out the Tutorial: Custom Reports and Statistics for more info on using custom stats.

[pkrotrollet]

The simplest way will be to duplicate the column "date_played" and change the "dateextract_date" part to "dateextract_day".
Once you have that column the same things apply - check out the Tutorial: Custom Reports and Statistics for more info on using custom stats.

In what table is that column. I really cant seem to find it !

[WhiteRider]

"date_played" is a Holdem Cash Player Statistics column, or the omaha/tournament equivalents.