Hi All,I am calling 2 values from my record type in the DATE and TIME format and I want it to produce the amount of days in between the dates.Saw this suggestion in a previous post in regular date format: tointeger(tointervalds(today()) - tointervalds(today()) but did not work from the date due to not able to calculate different in seconds?
Discussion posts and replies are publicly visible
Hello GusL6792
Please look at the below
docs.appian.com/.../fnc_date_and_time_calworkdays.html
"Expression evaluation error at function 'calworkdays': Could not cast from Record Field to Date and Time. Details: CastInvalidCould not cast from Record Field to Date and Time. Details: CastInvalid" is the error I receive
Please share the code snippet you are trying
GusL6792 said:Could not cast from Record Field to Date and Time. Details: CastInvalidCould not cast from Record Field to Date and Time. Details: CastInvalid"
May be you are not indexing the value but just mentioning the record Field.
HI Konduru, Thanks for the help I was able to resolve the issue. I did not add the correct Rule Input.
Great! GusL6792 Please do verify the answers that were helpful to you and mark this thread as closed as it would help others with similar issue get the answer quickly.