Skip to main content
Inspiring
Oct 21, 2024 7:44 AM UTC
Question

Custom record field

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
    Employee
    Oct 21, 2024 9:21 AM UTC

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

    stefanhelzle0001
    Brainy
    Oct 21, 2024 9:51 AM UTC

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