Formula for Next Day of the Week - InfoPath Dev
in

InfoPath Dev

Formula for Next Day of the Week

Last post 04-27-2016 07:06 AM by dblakester. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 04-20-2016 10:21 PM

    Formula for Next Day of the Week

    I'm sure there is a way to do this but I'm too new to figure it out. My Change Request form is filled out by the requestor, and I need the meeting date field to display the next meeting, which are always on Tuesday's at 1300. On the morning of the meeting, I have a cut-off time of 1100 so I need any forms filled out after 1100 on Tuesday to display next Tuesday's date. Hopefully, this explanation makes sense. Thank you for any help!
    Filed under: , ,
  • 04-25-2016 09:19 AM In reply to

     Attached certainly is the basics of the form for each Tuesday. The only piece I've not been able to test is being on a Tuesday before 11. If I'm in the office hopefully I can test tomorrow, but this should get you going.

     

    W 

  • 04-25-2016 04:53 PM In reply to

    Thank you very much for you efforts and response. I'll keep looking for your solution for the 1100 cut-off time and look forward to incorporating your solutions into my form. I've attached a copy of my form that I'm trying to incorporate your solution into. The "CCB Meeting" cell is where I'm looking for the date to show when the form is opened before it is submitted. Thanks again for all your help! Dennis
  • 04-26-2016 02:11 AM In reply to

    Re: Formula for Next Day of the Week

     Not the prettiest, I'm sure there is an all in one rule, but cracked it.

     Add a field called CurrentTime with the default value - substring-after(now(), "T")

    Then on field 2 with the rule called Tuesday before 11 add the following condition field2=0 and CurrentTime is less than 11:00:00

    Set field3=field1 

     

     

  • 04-27-2016 07:06 AM In reply to

    Re: Formula for Next Day of the Week

     Thank you very much for all your help! It will make a world of difference in my form.

Page 1 of 1 (5 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.