Calculated column formula to calculated value

This should replicate what you're trying to achieve. 

formatDate(dateAddDays({Common:CurrentDate}, (7-(new Date ().getDay()))), "d")‍

Breaking it down into parts: 

//{Common:CurrentDate} === 3/7/2018

//new Date ().getDay() === 3 (aka: Wednesday)



formatDate(dateAddDays({Common:CurrentDate}, (7-(new Date ().getDay()))), "d");

// translated...

// formatDate(dateAddDays(3/7/2018 12:00AM, (7 - (3))), "d");

// translated... 

// formatDate(dateAddDays(3/7/2018 12:00AM, 4), "d");

// translated... 

// formatDate(3/11/2018 12:00AM, "d");

// translated... 

// 3/11/2018
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

For my understanding, what is "new Date" and ".getDay?" Where are these coming from? 

That's just basic javascript (JavaScript getDay() Method or Date.prototype.getDay() - JavaScript | MDN). 

Calculated Value control Formulas are just evaluating javascript at the end of the day, so you can use it inside of there with no problems (most of the time). 

I figured. However, not getting a result when I preview it, hence I asked. This is what I have: 

Make sure that the view options in the properties of your calculated control are set to ReCalculate value on View:

Otherwise you won't be able to preview it. 

Hmmmm. Mine seems to still be blank...

Please copy and paste the code in my first reply into your formula field. You have a typo after the getDay where you have left off the invoking parentheses. 

My man! Perfect! Preciate it!!

nmarples‌ Do you know if there is a way to restrict a datepicker to not allow for future dates. I was trying to come up with an expression within the Date/Time control to do this, but I think its going to have to be done with javascript. 

With that said, I think I'm close. I know I can do the following or something similar: 

$('#datepicker').datepicker({ maxDate: 0 })

which would essentially not allow for any date past 'today.'

I'm having trouble converting this to being used on the form. I think I would need to store it in the javascript variable and reference it, but I'm not sure.

Hi,

sorry to hijack this thread but as I have an issue similar to this but have a formula on premise which works and want it to work in o365, I thought I'd add it.

It calculates from the current date the date of the previous friday:

=IF(WEEKDAY([Current Date])<6,[Current Date]-(11-WEEKDAY([Current Date])),[Current Date]+5-WEEKDAY([Current Date]))

However, I'm a bit stumped as to how to imp[lement it in the samesimilar way as to how you solved this one with your formula.

Any help would be much appreciated.

Regards

Julian