Hi
i am trying to filter the createdOn filed with both data and time Example : I need to get data from 16-04-2024 1:00AM to 16-04-2024 2;00AM
can any one help me how to implement this ?
Discussion posts and replies are publicly visible
Vattikundala Dinesh You can try this
a!queryFilter( field: /*Replace with your createdOn Field*/, operator: "between", value: { todatetime("04/06/2024 1:00 am"), /*Add You StartDate*/ todatetime("04/16/2024 2:00 am") /*Add Your EndDate*/ } )
But i am trying this for the userfilter field in record type ?
hi Vattikundala Dinesh are you looking this type of user filter in record type search ?
Hi Abhishek Karumuru yes along with that i need time as well to filter the records
Vattikundala Dinesh You go through this to understand date Range filter in record.https://docs.appian.com/suite/help/24.1/filter-the-record-list.html#:~:text=To%20create%20a%20date%20range,Filter%20Type%2C%20select%20Date%20Range.
is the above one will give me the date and time filter in user filter record type?
hiVattikundala Dinesh AFAIK, you cannot show time in record date range user filter, you need add manually date time field and pass your value and filter your query data, based on the data time given . Please find the example below code for reference
a!localVariables( local!startDte, local!endDte, { a!dateTimeField(label: "start",value: local!startDte,saveInto: local!startDte), a!dateTimeField(label: "end",value: local!endDte,saveInto: local!endDte), a!gridField( data: :/*your query rule*/(startDate: local!startDte,endDate: local!endDte).data, columns: { a!gridColumn( label: "col1", value: fv!row.id ), a!gridColumn( label: "col2", value: fv!row.data ), a!gridColumn( label: "col3", value: fv!row.date ) } ) } )