On my list, I have a column called 'Month' and another calculated column called 'current month' which obviously shows current month.
How can I adjust the views, so that I can only show the Month = current month
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
You can create two calculated columns to get the start date and end date of the month of the date column. Then check if the start date of the month of the date value is less than or equal to the current date [Today] and end date of the month of the date column is greater than or equal to the current date [Today]. If yes, it is in the current month.
"Start of Month" =DATE(YEAR([date]), MONTH([date]), 1) "End of Month" =DATE(YEAR([date]), MONTH([date])+1,1)-1
I can see that this would work, however it would require me to then make changes to my calculation in both the column itself and then in the formula if I needed to update it in the future. I did find, however, that if I just removed the xsl formatting then the field would display correctly. For example, when the custom list form is inserted, the calculated field is added as something like this:
<xsl:value-of select="format-number(@CalculatedField, '$#,##0.00;-$#,##0.00')"/>
If I just remove the formatting as below, it displays just fine:
Perhaps there some issue with the formatting since the calculated field (at least in this case) is already formatted as currency in my SharePoint list.
For More Reference