Skip to main content
S
suyogk0001
June 28, 2023
Question

need help on date field

  • June 28, 2023
  • 10 replies
  • 0 views

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
    stefanhelzle0001
    Brainy
    June 28, 2023

    Is that a UI question?

    Did you check the a!addDateTime() function?

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

      S
      suyogk0001Author
      June 28, 2023

      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
      mikes0011
      Brainy
      June 28, 2023

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

      The Expression Guru
      harshitb6843
      harshitb6843
      June 28, 2023

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

      S
      suyogk0001Author
      June 28, 2023

      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
      mikes0011
      Brainy
      June 28, 2023

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

      The Expression Guru
      Terms & ConditionsAccessibility statement