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,

  1. Create a new column called Today (Single line of text).
  2. Create a calculated column, name it anything you want, say 'CurrentDate'.
  3. In the formula, insert the column you created previously 'Today'.
  4. Set the data type to 'Date and Time'.
  5. 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.
  6. Now delete the 'Today' column you created in first step. Don't worry, just go ahead.
  7. Add the 'CurrentDate' column to your view and check the value.
  8. You should see today's date in there.
  9. 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], if there is a need for calculated column that involves it.

Comments

Post a Comment

Popular posts from this blog

Power BI Refresh Issue: unable to convert the value '' from the source data type 'VT_BSTR' to the expected data type 'VT_I8.

Image
While scheduling refresh in Power BI, you might get below error . Issue: Unable to convert the value '<pii></pii>' from the source data type 'VT_BSTR' to the expected data type 'VT_I8 .     Cause/Reason Behind: Column datatype mismatch between power bi desktop and power bi cloud report. Solution: Edit query in power bi desktop and change the data type so it’s in sync with Power BI service/cloud. Example: In my case, I have modified a column’s datatype from decimal to whole number (to display no. of days). Now power bi desktop and power bi service synced up and I could perform automatic data refresh.
Read more

SharePoint Designer workflow restore previous version - Applies to SP versions - 2013,2010 and 2007

Image
Today I got into a situation to restore the previous version of one of the SharePoint Designer 2010 workflows, created in SharePoint Designer 2013. 1.      In the left pane of SharePoint Designer, click the little pin icon next to  All Files . 2.      Now look for the folder Workflows on the right pane and look for your workflow. 3.      My situation was to restore a previous version of the workflow “Reminder Test. Select and expand it.  4.      Each of these files has a set of versions. Right click on the XOML file and choose  Version History . Select the version you would like to restore. (For my there is some problem in loading version history and so couldn’t provide the screenshot) 5.      Click  Restore . 6.      Right click on the next file, the XOML.rules. Go find that exact same date/time of the f...
Read more