SharePoint: Fiscal year as Calculated column 

=IF(MONTH(Created)>2,"FY "&YEAR(Created)+1,"FY "&YEAR(Created))
here Month(Created)>2 can be changed as per business need. I had a scenario to show fiscal year between February of every year

Comments

Post a Comment

Popular posts from this blog

Run Powershell script on Remote Computer/Server

Image
PowerShell Remoting allows you to run individual PowerShell commands or access full PowerShell sessions on remote Windows systems.   PowerShell is locked-down by default, so you’ll have to enable PowerShell Remoting before using it. This setup process is a bit more complex if you’re using a workgroup – for example, on a home network — instead of a domain.   Enabling PowerShell Remoting On the computer you want to access remotely, open a PowerShell window as Administrator – right click the PowerShell shortcut and select Run as Administrator.   To enable PowerShell Remoting, run the following command (known as a cmdlet in PowerShell):  Enable-PSRemoting -Force This command starts the WinRM service, sets it to start automatically with your system, and creates a firewall rule that allows incoming connections. The -Force part of the command tells PowerShell to perform these actions without prompting you for each step     Workgroup ...
Read more

SPDActivities - DP.SharePoint.Workflow - Workflow failed to run

Image
One of my SP 2016 application is using SPDActivities of Email extended feature of DP.SharePoint.Workflow to provide custom "From" address. But customers started to complain that they are not getting reminder emails anymore. Find below my STAR analysis, Situation : Recently I was facing an issue - Approval workflow failed to run. Customers not getting reminder emails anymore. Task : - Planned to look into SharePoint services, IIS site, web.config files (WFE and App Server), Latest patch/MS update/CU, Users permission. Analysis : Started looking into each below items,  - SharePoint Timer Service and Administration services were running and good - Account which is running the workflow got required permission - DP.SharePoint.Workflow got activated for the web application - Checked into web.config file in WFE server and App Server for below sections Under <SafeControls> below 3 lines need to added both in WFE and App server web.config files, ...
Read more

Volatile function error for SharePoint calculated field current date

  Today's Issue: Volatile function error for SharePoint calculated field current date While creating calculated column to find date difference, I encountered this error. Here I have provided the resolution to fix it, Create a  new column  called  Today  (Single line of text). Create a  calculated column , name it anything you want, say ' CurrentDate '. In the  formula , insert the column you created previously ' Today '. Set the data type to ' Date and Time '. Set the Date and Time format to ' Date Only '. You can even select Date & Time if you would want to use hours/minutes as well. Now  delete  the ' Today ' column you created in first step. Don't worry, just go ahead. Add the 'CurrentDate' column to your view and check the value. You should see today's date in there. Modify the formula as required, you can use the column Today just like the function [Today] without any issues. Same approach could also be used for [Me],...
Read more