Skip to main content
Known Participant
Jun 28, 2023 9:21 AM UTC
Question

need help on date field

Hi all,

having one requirement like there are two dates  date 1 & date 2.then date 2 should be equal to + 1 day of date 1 (only week days, no sat, Sunday) what should I do?

    10 replies

    stefanhelzle0001
    Brainy
    Jun 28, 2023 9:32 AM UTC

    Is that a UI question?

    Did you check the a!addDateTime() function?

    docs.appian.com/.../fnc_date_and_time_adddatetime.html

    Known Participant
    Jun 28, 2023 12:09 PM UTC

    yes its Ui question I have to display date 2 on the basis of date 1 and in that only week days will consider like

    Date 2= Date 1 + 1 ( business days only )

    mikes0011
    Brainy
    Jun 28, 2023 12:38 PM UTC

    Did you read the documentation Stefan linked, by any chance?  Because it seems to contain your answer...

    The Expression Guru
    harshitb6843
    Brainy
    Jun 28, 2023 9:53 AM UTC

    if(
      ri!date1+(day()*1)=ri!date2,
      null,
      "There was a problem "
    )

    Known Participant
    Jun 28, 2023 12:30 PM UTC

    Hi Harshit

    thanks for quick response but date 2 should auto populate on the basis date 1

    and Date 2= Date 1 + 1 ( business days only ) so for skipping Saturday and Sunday what should I do?

    mikes0011
    Brainy
    Jun 28, 2023 12:35 PM UTC

    Can you post the code that you've tried so far?

    The Expression Guru