Calculating the week end date for any given week - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Calculating the week end date for any given week

Last post 11-28-2016 02:09 PM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 11-17-2016 10:08 AM

    Calculating the week end date for any given week

     There is a way in a SharePoint list to use a calculated column to calculate the week ending date (based on a Sunday through Saturday week) using any date in that week.    This is the formula you would use in the calculated column.   Because it uses the weekday function I am not sure how to change it to use in InfoPath.

     =TEXT([Selected Date]+(7-WEEKDAY([Selected Date])),"mm/dd/yyyy")  "Selected Date" being the name of the column that contains the date for the calculation.

     How would I do this in InfoPath?

     

  • 11-28-2016 02:09 PM In reply to

    Re: Calculating the week end date for any given week

     I don't know of a similar option in InfoPath - probably a way with qRules, or someone may have come up with complicated rule variation - https://aemadhavan.wordpress.com/2013/07/24/calculating-day-of-the-week-in-infopath-without-code/ might be a starting point....

    Hilary Stoupa

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