How to filter on CreatedDateTime field in a Report design or Inquiry?
I am attempting to generate a report that a user has requested that they can run at the end of the day showing them everything that they entered in AP that date. Attempting to add a filter on a new design where the user can select the date that they want the report to run for. Figuring we can have this date filter against CreatedDateTime field on the transactions equal to the parameter date. This is not working for me and I have a feeling it is because this field is date time etc.. Very frustrating and feel this should be something very easy to do already. Anyone have any advise as to how to accomplish this or what I am doing wrong? This will be needed in other areas as well. Thank you!
I've run into a similar issue looking at time entries as well because there is the time component to these entries as well, but when you pick a date from the menus in report designer and the GIs, it seems to default to midnight on that day and not all users are always in the same time zone as the system default, so some items although they happened on the "business day" in the system they were next day transactions.
For a few of my time entry type reports, I ended up just adding an extra day using a formula (DateAdd) to pick up these items (so for the GI, if I run it for a single day it should run for a 24 hour period - from 12:00 am this morning to 12:00 am tomorrow morning). It's not great, but it covered our requirements.