Sharepoint Calculated Field to Compare an Expiry Date to Today
I am working on a system to record the dates which training is undertaken, calculating how long it is valid for, and recording a date for when it is required to be updated.
I have a date field for when the Training Expires, and I want a calculated field that compares today's date to the date of expiry. If the date is 6 months away or less, then it will be in a Caution status, and if the value has gone past expiry, it is expired.
My plan is to include a Calculated Field in the sharepoint list that this is held in, receiving data from a PowerApp.
The Expiry Date field is calculated and formatted as a Date and Time Field but only uses Dates. My current calculation is this:
=IF(DATEDIF([TrainingLog_ExpiryDate],NOW(),"m")=<0,"Expired",IF(DATEDIF([TrainingLog_ExpiryDate],NOW(),"m")=<6,"Caution",IF(DATEDIF([TrainingLog_ExpiryDate],NOW(),"m")>6,"Safe","Error")
This is coming up with a Syntax error, and I do not really know why as I'm getting no errors other than syntax. Can anyone help, or even offer a better solution for this?
Please use following formula.
=IF(TrainingLog_ExpiryDate<=TODAY(),"Expired",IF(TrainingLog_ExpiryDate<=TODAY()+180,"Caution",IF(TrainingLog_ExpiryDate>TODAY()+180,"Safe","Error")))
Result:
- Sort list of dates by year & quarter
- How to dynamically adjust ylim in base R plots?
- convert a list which has single elements and lists into a flat list
- Get last element of Stream/List in a one-liner
- The most efficient way to remove first N elements in a list?
- WPF Filter a ListBox
- Android: List my app's own files is not working on Android 11+
- Transpose list of lists
- Getting an object attributes while iterating through a List in Struts 2
- Sort a list of lists when one of the sort items is text month
- Copy of a list (or something else) in Scheme
- Convert [key1,val1,key2,val2] to a dict?
- How to Find Unique Pairs in a List That Add Up to a Target Sum in Python?
- Removing duplicates in lists
- Struct with fields of List type, but set to null: Heap allocation?
- (Java) How to map one column of a CSV file to another column of a different type?
- Check if specific value in a series is NaN
- What does this list permutations implementation in Haskell exactly do?
- Change all occurrences of an Int in a linked list using IntNode Java
- Nested list into data frame
- Implement insert in haskell with foldr
- How to sort the earliest time stamp in the list in java?
- Removing duplicates from the list of pydantic objects
- Is there a clever way to convert a compex string to multiple lists in Python 3
- return if list is consecutive within python col
- How to use <s:select> tag with two lists of the same type in Struts 2?
- Why are arrays still in C# when we are actually always using List<T>?
- Python -Intersection of multiple lists?
- Initializing List<T> with given number of nulls without loop?
- Python: How to RECURSIVELY remove None values from a NESTED data structure (lists and dictionaries)?