InfoPath 2007 Date Picker formula to calculate specific day of week - InfoPath Dev
in

InfoPath Dev

InfoPath 2007 Date Picker formula to calculate specific day of week

Last post 03-29-2013 03:00 PM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-29-2013 06:54 AM

    • rmcgowan
    • Not Ranked
      Male
    • Joined on 03-29-2013
    • Maine
    • Posts 1

    InfoPath 2007 Date Picker formula to calculate specific day of week

    Here is the scenario I am trying to complete. I have certain windows of time I would like to prefill into the date picker based on user selection. For instance if the user selects a radio button that says Thurday I want the date picker field to automatically fill with next Thursday's date and also prefill the time with 8PM. Is there anyway of doing this? Thank you all in advance for your help!

  • 03-29-2013 03:00 PM In reply to

    Re: InfoPath 2007 Date Picker formula to calculate specific day of week

    That gets a little tricky, because you have to have a way to find out the number of days between today and the next Thursday in the week - InfoPath doesn't really offer anything out of the box for this. That leaves you with writing code or using something like qRules... or you may be able to find an existing web service that would get you the info you need - you need to be able to find out the day of the week for today, so you have a way to calculate how many days you'd need to add to it to get to next Thursday.... setting the time to 8 PM is just a matter of getting the date time format right - you want yyyy-MM-ddThh:mm:ss, like 2013-03-29T15:00:00

    Hilary Stoupa

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