I'm currently working for a business that runs restaurants/bars that open between 7am to 4am (the following day).
Ideally, I would like to create daily reports for the previous day's business (So - From Yesterday 7am to Today 4am) but I can't see a way of doing this?
Is this possible in your experience?
5 件の回答
Hi Matt,
You can do this but you would have to create 2 new formula fields, what you will do is if you have a date/ time field Like Created Date, using a Forumula date field and a formula Time field, you can break it down and then make them filters in your report like this:
(Right click on image and then open in new tab to enlarge the picture)
The formulas you will need will be:
TIMEVALUE( Fieldname)
DATEVALUE(Fieldname)
