Hey Guys,
I am trying to create a task based on a date in a 'Next Deadline' Column.
As this is a repetitive monthly run needing to be completed by the x day of the month - it is a calculated column.
Odata filter doesn't like the calculated column from Sharepoint.
Therefore I need to retrieve the list of dates and compare them to today.
I've tried many different combinations of apply to each but I just haven't come across the solution.
Any help appreciated.
Rich
Solved! Go to Solution.
I've Solved this now.
Little did I realise (/notice) that as we are currently at utc -1 hour and the sharepoint time was 00:00 taking away that hour meant the day before was being returned hence why none of my tests worked.
addHours was the fix
I've Solved this now.
Little did I realise (/notice) that as we are currently at utc -1 hour and the sharepoint time was 00:00 taking away that hour meant the day before was being returned hence why none of my tests worked.
addHours was the fix
User | Count |
---|---|
95 | |
45 | |
21 | |
18 | |
17 |
User | Count |
---|---|
142 | |
50 | |
43 | |
40 | |
31 |