Hi All,
I have a customer using SP2013 on prem, there is a workflow that extracts date information from the created date on a document - month and year, to allow for indexing and filtering.
I thought it was working well until I got a complaint that at the start of everything month the "current month" view is empty even though documents have been added.
Upon investigated I realised that by saving the date as ISO it was saving it as a different time zone (we're in New Zealand). So for example our date format is DD/MM/YYY so today being 1st of August I have a document with a time stamp of 01/08/2018 11:19:10 a.m., however the ISO formatted date is 2018-07-31T23:19:10Z, so this document is being listed as being created in July not August.
How do I correct the ISO date to reflect my timezone?