Hi guys,
in one of our scenarios, I want to take only the year of a given date (say 2020), and then set another date to the 31st of December of the mentioned year (so, 31-12-2020). For this, I want ti use formatdatetime () function as described for PowerAutomate here , but using a Workflow instead of a Flow. So in PowerAutomate, the function would be something like this:
formatDateTime([timedatefield],’31.12.yyyy’)
I found a promising Workflow from the Ultimate Workflow Toolkit for this issue
Unfortunately, it does not seem to work. Here is what I did:
- I added a workflow step usinh the UWT Toolkit
- Then I filled in the workflow form with the needed information:
- Now, I want to use the result of the UWT workflow in a "update record" workflow step.
But when I look for local values in the formlar assistant, I can find my UWT workflow step "Cut date to 31.12.yyyy", but there is nothing I can select.
Am I missing something? Does anybody know how to use "FormatDateTime" in a workflow?
BR
Flo
