How to add days to a date field in a flow with no coding

[Moedeb]

I wanted to add this as an article because I've seen a lot of posts of people wanting to add days / time to fields based on other dates and this is a no code way to do it.

For some reason I cannot add an article - there is no "Create an article" button, so I'm posting it here

How to add days to a date field in a flow with no coding

Eg: original date + 10 days = new date

For this example the trigger will be a change to a variable field added to the sys_user table called:

• original date (u_original_date)

The action will be to add 10 days to the original date and update another variable field on the sys_user table with the new date.

1. Create a new flow and add a trigger: Record >> Updated
   
   
   
2. Add the table “sys_user” (or whatever table your date fields are on)
   
   
   
3. Add an action – Update record with the record being the trigger record (User record)
   In this case we are just going to update one field “New date (u_new_date)” so that is all that is being added.
   
4. The table will auto populate with the trigger records table (sys_user)
   
5. Add the field to be updated “New date”
   
6. Using the data pill picker find the “Original Date” field (as that is the one we want to add 10 days to).
   Click on the icon and the “transform functions” window will appear.
   

7.  Once added you will see a  icon on the data pill (if not just hover your mouse over the data pill)

   
8. Click on the icon and the “transform functions” window will appear.
   
9. Select “Date & Time” (it doesn’t matter if your field is just a date field)
   
   
   
10. Then select “Add Time” and you will see fields where you can add time in a number of ways (days, hours, minutes, seconds)
    
11. Add 10 to the days field and click “apply”, the window will update and “Add Time” will be shown under the “Applied Transformations” label.
    
    
12. Click outside the “Transform Functions” window to close it, you will also see that the  icon is now highlighted to show that a transform function is applied.
    

13. Activate your flow and manually make an update on a user record to the “Original Date” field, then update/save the user record.
    Note: You may need to refresh your page to see the updated “New Date” field now populated with a date 10 days after the “Original Date” value.

    
    
    

[Mark Manders]

Thanks!
ServiceNow has indeed closed the possibility to have articles/blogs posted by just anyone. Somewhere there's an article stating that you can email the community to ask to have this possibility added for you, but doing that just never gets a reply. I think they aren't using a decent platform to handle incoming emails. 😊

[Bidduam]

@Moedeb very cool, so easy if you know how (and now we do), love how much I am learning that can be done in a flow where in the past a business rule or a script include would have needed some smart coding done.