I have a scenario where I am fetching data from a table and need to add 3 days to the date time field and display it in a grid column
Have tried the following:
a!textField( value: a!forEach( items: local!datasubset.data, expression: if( or( index(fv!item, "IS_SCHEDULED")= "0", isnull(index(fv!item, "IS_SCHEDULED")) ), index(fv!item, "create_timestamp", null), " " ) ),readOnly: true)
I have tried using time, day, hour in different combinations but getting an error
Error in a!forEach() expression during iteration 1: Expression evaluation error : Cannot add incompatible operands of type Any Type and type Time.
Discussion posts and replies are publicly visible
Above, where you are adding 3?
If it is a date time field, simply add 3 in it. Create expression, rather than using for each in a textField directly. and use it in grid's a!textField().
Error you are getting because your one operand is of Any Type. It should be date and Time.
I have tried adding 3 in ri!testDateTime and it is working perfectly.
Eg: ri!sampleDate + tointeger(3)
Output :- 9/1/2019 2:30 AM EST
Thanks so much sandeepd , this works.
I want to add 1 in time. Please suggest
© 2023 Appian. All rights reserved.