What would be the function to set the Date property fixed date (15th Oct) and checks the same date every year
I want to trigger a task on 15th Oct of every year. For this I am using a wait shape with Reference date/time property. What would be the function to set the Date property fixed date (15th Oct) and checks the same date every year? ex. if 15th Oct 2023 is already triggered then next trigger would be on 15th Oct 2024.
***Edited by Moderator Rupashree S. to add Capability tags***
Accepted Solution
Updated: 5 Apr 2024 9:47 EDT
Maantic
IN
you can queue it based on your requirement by setting the date for a dedicated queue.
when the current year execution is done then again re-queue it for the next year.
or Job-scheduler is another option.
Aaseya IT Services Pvt Ltd
SA
@SonalM99 try below syntax, should work.
"10/15/" + FormatDateTime(CurrentDateTime(),"yyyy","","")
if not working, try to convert in datetimeformat once yu get the date from above syntax.
BARCLAYS
IN
@Hitesh Jain Hi Hitesh, thanks for the function but this wont work in my case. Lets say user finished the task on 18th Oct of 2024, then this function will set again 15th Oct of 2024 as per the function coz we have SLA of 3 days to finish this task. This function will always set the current year. I need to append the date for next year i.e next execution should be on 15th Oct 2025.
Accenture
NL
@SonalM99 so any cases before 15 October 2023, should have the referenced property date as 15 Oct 2023. Any cases after 15 October 2023, should have 15 October 2024. Is this the requirement?
BARCLAYS
IN
@DineshKumarD9112 Yes Dinesh. It should take current year of 15th Oct, it should trigger every year on 15/10
Accepted Solution
Updated: 5 Apr 2024 9:47 EDT
Maantic
IN
you can queue it based on your requirement by setting the date for a dedicated queue.
when the current year execution is done then again re-queue it for the next year.
or Job-scheduler is another option.