I’ve been confusing myself no end with temporal set rules and I’ve finally figured out it’s because I thought “today” meant what it sounds like – whereas in fact it means “now”.<\/p>\n
<\/p>\n
So “1 day from today” means “this time tomorrow” and “1 day prior to today” means “this time yesterday”.<\/p>\n
This is very relevant when you have rules that do things like disable an account the day after the listed end date. Your transition set may have a rule like this:<\/p>\n
“EmployeeEndDate prior to today”<\/p>\n
This sounds clear enough – if the EmployeeEndDate is yesterday or earlier then transition in to the set and trigger the appropriate workflows. However the reality may be different with\u00c2\u00a0some accounts getting disabled on<\/span> the end date, rather than waiting until the next day.<\/p>\n By default the FIMTemporalEventsJob runs in SQL at 1am. If the user’s EmployeeEndDate is set to today’s date with a timestamp of “12:00:00 AM” this time<\/em> is actually in the past when the 1am job runs, so the account gets disabled. Conversely if the timestamp was something like “8:00:00 AM” that time would still be in the future and the account would not get disabled until the following day – even though in both cases the date part\u00c2\u00a0is the same <\/strong>and we should be able to expect the same behaviour.<\/p>\n The most important thing to do is get all timestamps set to a consistent “12:00:00 AM” local time wherever the date is\u00c2\u00a0of interest but we don’t care about the time. Controlling data entry points is a big part of it. The FIM RCDC forms will append “12:00:00 AM” when only the date is entered – but there’s no way to stop someone entering a timestamp as well. Scripts can help but you need to hardcode the XPath filter with specific dates – I have some data quality tasks that check particular date attributes up to 20 days in the future (one day at a time)\u00c2\u00a0looking for incorrect timestamps and normalising them. It’s not pretty, but seems to be necessary.<\/p>\n","protected":false},"excerpt":{"rendered":" I’ve been confusing myself no end with temporal set rules and I’ve finally figured out it’s because I thought “today” meant what it sounds like – whereas in fact it means “now”.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":[]},"categories":[42,60,54],"tags":[],"class_list":["post-2720","post","type-post","status-publish","format-standard","hentry","category-fim-2010","category-fim-2010-r2","category-sets"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pkp1o-HS","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/posts\/2720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/comments?post=2720"}],"version-history":[{"count":1,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/posts\/2720\/revisions"}],"predecessor-version":[{"id":2721,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/posts\/2720\/revisions\/2721"}],"wp:attachment":[{"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/media?parent=2720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/categories?post=2720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wapshere.com\/missmiis\/wp-json\/wp\/v2\/tags?post=2720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}