I've seen the questions around filtering on date/time field. Is there a way to change the value within the filters being applied so that it reads the date from the date/time field and filters on that?
up to 19.1 version, there is no such filter option but it is available on 19.2 version.
Hope it will help.
naomi0001 - You can change your rule Input parameter data type to Date which should automatically convert the date time to date and pass the same t query entity for filtering the records.
Thanks for your help. I edited the CDT to read as a date instead and was able to apply the filter. this is for a record.
Please keep in mind that date/time fields do down to milliseconds.,so if you really did want to ever even query by a date/time, you should use a view to truncate it to at least minutes, but hopefully hours. Then, in this case, you are no longer querying really by date and time. Does that make sense?
So, when you have those kind of requirements, try to plan for other data capture alternatives to support more filtering.
Discussion posts and replies are publicly visible
© 2020 Appian. All rights reserved.