cancel
Showing results for 
Search instead for 
Did you mean: 
tibes
Nintex Newbie

Refreshing "Today date" daily

Hi!

I would like to add a "Today date" column to be able to show a deviation between the deadline of a task and today date. This should be refreshed daily to be able to monitor our system, but I couldn't find a solution so far. As I know [Today]function isn't refreshing and cannot be used by calculated columns so I started a workflow with adding the following functions and updating the list item I created but I don't know how to repeat the workflow exactly to be able to refresh daily:

Thank you in advance!

0 Kudos
Reply
6 Replies
Automation Master
Automation Master

Re: Refreshing "Today date" daily

You should use the set variable action‌ and there you can set your "Date/Time" variable to "Date when action is executed". That way you can obtain the current date:

Regards,

Tomasz

0 Kudos
Reply
tibes
Nintex Newbie

Re: Refreshing "Today date" daily

Hi Tomasz,

I already tried to use this function but how can I make it sure that the date will be refreshed everyday without modifying the form which makes the workflow running?

0 Kudos
Reply
Automation Master
Automation Master

Re: Refreshing "Today date" daily

I don't know how your workflow is constructed. If it is ran once, when the item is created/ modified then you have no option to update value daily.

To achieve what you are talking about you should use site workflow. Unfortunately there is no "scheduling" yet for O365 Site Workflows (so you cannot schedule it to run once a day), but you can create a site workflow with a loop and pause action (pause for 1 day). That way you will have always running workflow, executing its actions only once a day.

Regards,

Tomasz

Reply
tomcastiglia
Nintex Newbie

Re: Refreshing "Today date" daily

BTW - Tibor Csaba there is also 3rd party workflow scheduler solution from Plumsail that enables scheduled workflows in Office 365.  I haven't used it myself, but I hear it works well with Nintex and its costs $199/year.  Here's a thread with some reviews: Anyone using Plumsail to schedule workflows? 

Reply
tibes
Nintex Newbie

Re: Refreshing "Today date" daily

Thanks for all of your comments! Unfortunately we don't have the site workflow feature currently, so I had to solve otherwise. I will check this Plumsail add-on later because it sounds interesting.

Anyway I could solve the issue with the following steps:

1. With the "Add time to date" function I set "0" for days, hours, minutes to add to the creation date and save the result as a "Today date" variable.

2. After it I update "Today date" column with this value.

3. I pause the workflow until 1 day.

4. A loop starts with the condition the action hasn't been completed yét.

5. I add 1 day to the "Today date" with the "Add time to date" function.

6. I update "Today date" column.

7. Workflow pauses for 1 day.

0 Kudos
Reply
Automation Master
Automation Master

Re: Refreshing "Today date" daily

It is impossible not to have Site Workflows. They are available here (Site Contents --> Nintex Workflow for Office 365):

After you click it you will enter workflow gallery for site workflows. To trigger you must go to: https:/[tenant-name].sharepoint.com/[...]/_layouts/15/workflow.aspx.

Regards,

Tomasz

Reply