In our Nav we have a Custom Table that store data for Web Orders (Customer places order online and the order is automatically added/released from Nav)
This is our Table setup
i'm trying to do a matrix for the Times the order has come in.
7:00 AM 8:00 AM ect.
I'm very comfortable with Jet for 99% of formulas but ive never used any time filters.
Can anyone please help.