Skip to main content
Known Participant
Mar 8, 2021 9:16 AM UTC
Question

How to validate "Date" and "Date&Time" coming from external source

Hi All,

We have built an application wherein user inserts some records in excel and upload it to appian. We then parse those information and display them in appropriate appian controls. One issue that we are facing currently is related to Date or Date&Time entered by the user.

As user can enter date and time which may or may not be accurate in terms of how appian wants those data. Hence, It results into an error. 

Is there any way to figure out whether the date is valid or not as per appian? If its not, We have decided to show them in readonly textfield. Any help here will be appreciated. 

Thanks in advance

    2 replies

    New Participant
    Jan 21, 2023 9:42 AM UTC

    Were you ever able to solve this?

    stefanhelzle0001
    Brainy
    Jan 23, 2023 8:14 AM UTC

    I think the best approach would be to use the regex plugin and check your incoming data using an appropriate pattern.