Adding hours to datetime value

Question

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!!

sandeepd · Accepted Answer

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

Adding hours to datetime value

Top Replies