Create a task based on a date in a calculated column

[Ricardinh0]

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

[Ricardinh0 · Accepted 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