Contents
Date and time fields can have a default value of “Today” or “Now” that populates if you don’t enter another value in the field before saving an item. In your date/time column settings: If you choose type “ Date only ” you’ll get the current date If you choose “ Date and time ” you’ll get the current date and time
If you need a “live” always-updated value regardless of items being modified, you’ll need to create a separate “Today” column using Microsoft Flow or SharePoint Designer: This post also includes ideas for calculations using today’s date. Loading…
Can a list be updated with the current date?
They will not update automatically or regularly; just when a list item is modified. If you need a “live” always-updated value regardless of items being modified, you’ll need to create a separate “Today” column using Microsoft Flow or SharePoint Designer: This post also includes ideas for calculations using today’s date.
How to make a column with the current date?
After a long search on the internet I found there was no satisfying solution to make a column using the current date. However, I found out that when you modify the view of a list, you can put [today] in the filter section. This allows you to base the view of your list on the current date. This date will automatically be kept current.
The best approach is to use a Modified date with two Update Item actions. First to update the list with some dummy data or update the same column, now you will have the latest Modified date with time, which you can use current date time. I use the Call HTTP-Webservice action to get the current time and date.
If you click the ellipses next to the value option, there’s a selector for current date. You would simply use the set workflow variable action and use the current date or use the add time to date action and set 0 days/hours/minutes/seconds to Today.
How to create a current date and time variable?
If you click the ellipses next to the value option, there’s a selector for current date. You would simply use the set workflow variable action and use the current date or use the add time to date action and set 0 days/hours/minutes/seconds to Today. Made a super-ugly hack (solution?).