First and last day of a month in a year - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

First and last day of a month in a year

Last post 03-04-2020 01:56 PM by Sgt Shagrat. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 02-28-2020 09:18 AM

    First and last day of a month in a year

    Hi, I created a dropdown field where I have the name of the months and each month has a value corresponding at his numer of month (e.g. January = 01, December = 12 etc..). In another dropdown field I put the years. I've searching the formulas to fit two other field named "Start_Date" and "End_Date" when I choose between month and year taking into account the leap years. How I can do this? Thanks a lot Toomay
  • 03-03-2020 12:46 PM In reply to

    Re: First and last day of a month in a year

    There is really no easy way to do this in InfoPath. You might just want to create a SharePoint list with this data in it, just prepopulate with a bunch of years, months, start and end dates - probably could create the data for pretty far in the future with Excel and then create your new list off the spreadsheet.
    Hilary Stoupa

  • 03-04-2020 01:56 PM In reply to

    Re: First and last day of a month in a year

    Thank you Hilary, I've thinked something about it. I realize that is not so simple. In other way I'll try to use some rules to do it with a known period of years.
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.