Skip to main content
October 21, 2024
Question

Custom record field

  • October 21, 2024
  • 2 replies
  • 0 views

I want to create a custom record field that converts a string timestamp field to date or datetime just to use it in user filters. I chose the real-time option but it seems something is wrong with that because when I tried with sync-time evaluation it works. This is the code: 

datetime(
left(ri!stringTimestamp, 4),
mid(ri!stringTimestamp, 6, 2),
mid(ri!stringTimestamp, 9, 2))

instead of ri!stringTimestamp I am using the respective record field

    2 replies

    somasundaram.d
    October 21, 2024

    That is one of the limitation in writing your own expression that evaluates in real time. There are only limited custom functions available.

    stefanhelzle0001
    October 21, 2024

    The documentation has all the info and examples: https://docs.appian.com/suite/help/24.3/custom-record-fields.html