Ashley Posted June 30, 2023 Share Posted June 30, 2023 I am trying to create a report that uses a custom field that is for a date only. Not require the time. The filter for selection only allows Date/Time. Therefore when I try searching with just the date the results are unpredictable or don't show anything. Please advise how I can have a report that allows searching by date only or between two dates, excluding the time. Link to comment Share on other sites More sharing options...
Steve Giller Posted July 1, 2023 Share Posted July 1, 2023 If you have the internal SQL expertise you can manipulate a Date/Time value to return only the Date portion, alternatively you can use the Date Utilities offered by the iBridge (Cloud Automation) node to format a date-only value and store it in a Varchar field, then report on that. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now