General

Re: Default Date to First Day of Next Month

Hilary Stoupa — Mon, 06 Apr 2020 15:53:02 GMT

Thanks so much for taking the time to share your solution! :)

Re: Default Date to First Day of Next Month

NickiPT — Mon, 06 Apr 2020 13:56:49 GMT

I know this is many years after the fact but I figured out a solution to this and figured I would post it in case someone else came across this thread... Adding T00:00:00 to the end of the string doesn't solve it because what's happening is that when the formula adds one "+ 1" to the month string, it turns it into a single digit if your month is one of the first 9 months of the year. You need to create a field that will force a value with 2 digits and then incorporate that into your formula. So I ended up with three separate fields - possibly overkill but it works so here how it is set up:

1. Month_After_Received
Text field; its value is set by Date_Received.

2. Month_After_Recd_TwoDigits
Text field, its default value is:
concat(substring('00', 1, 2 - string-length(Month_After_Received)), Month_After_Received)

3. Date_Received:

// extract the month from this field and add 1 to it
a. Condition: When field changes
Action: Month_After_Received to: number(substring(., 6, 2)) + 1

// this is for all months other than December
b. Condition: substring(., 6, 2) != 12
Action: Date_Due = concat(substring(., 1, 4), "-", Month_After_Recd_TwoDigits, "-01T00:00:00")

// this is for December
c. Condition: substring(., 6, 2) = 12
Action: Date_Due = concat(substring(., 1, 4) + 1, "-01-01T00:00:00")

Re: Default Date to First Day of Next Month

Hilary Stoupa — Thu, 07 Nov 2013 16:50:02 GMT

Ah, now I know what's up. We need to add " 00:00:00" to the date. That's a space and 0s for time for hours, minutes, etc. This is because SharePoint doesn't have a date data type, but has a date time data type. Can you try that? With a concat? And see if that helps?

Re: Default Date to First Day of Next Month

mecamden — Thu, 07 Nov 2013 16:40:14 GMT

Here is my problem. I'm using another date field to populate the Order Date field. The functionality is great and working fine, it's the formatting however that I can't figure out. I need the date to display as month/day/year format rather than year-month-day format. The form that you sent me is in the right format, but because I am using a SharePoint list and not a Form Library the date that is being pushed out is in the wrong format. Without the right format the user would have to retype in the correct format or use the calendar icon to pick a different date.

Re: Default Date to First Day of Next Month

Hilary Stoupa — Wed, 06 Nov 2013 23:28:23 GMT

Can you attach a screenshot under the options tab showing the issue?

Re: Default Date to First Day of Next Month

mecamden — Wed, 06 Nov 2013 22:05:23 GMT

I used the created field to populate the "First Day of the Month" field. And the order Date field is defaulted to the "first day of the month" field. I needed to make sure that the Date field can be changed later on.

Re: Default Date to First Day of Next Month

Hilary Stoupa — Wed, 06 Nov 2013 20:46:41 GMT

Where is your rule? I expected to see it on the Order Date - is it someplace else?

Re: Default Date to First Day of Next Month

mecamden — Wed, 06 Nov 2013 20:41:03 GMT

This is the form we were talking about in our messages :)

Re: Default Date to First Day of Next Month

mecamden — Tue, 05 Nov 2013 13:57:26 GMT

Thank you so much!

Re: Default Date to First Day of Next Month

Hilary Stoupa — Mon, 04 Nov 2013 20:07:17 GMT

This would get a little tricky with default values, but can be done rather simply using rules. I've attached a sample - save it locally, right click and select design to open in design mode. The only problem you may have is that the rules could execute again and overwrite the user's entry, so you may need to add some other logic to handle for that.

Default Date to First Day of Next Month

mecamden — Mon, 04 Nov 2013 17:18:33 GMT

I'm trying to write a formula that will set the default date on a date picker control to the first day of the next month. For example, if I were filling out the form today (November 4th), the default value of the date picker would be the 1st of December. Or if I was filling out the form on the 20th of July, the default would be the 1st of August. Any answers or direction are greatly appreciated.