Appian Community and Appian Academy are being upgraded. From July 24–August 3, the Appian Community will be in read-only mode. During this time, the site will be read-only and user registration will be disabled. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
Hi,
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.
TIA!!
Discussion posts and replies are publicly visible
Hi apoorvam,
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,
Sandeep
Thanks so much sandeepd , this works.
I want to add 1 in time. Please suggest
now()+intervalds(0,1,0)
docs.appian.com/.../Function_Recipes.html