Automatically Update Date Field

Question

I use QB to keep track of thousands of articles that I schedule for the e-newsletters my company sends out. Each article is a project. I am constantly updating these projects, like from "Assigned" to "Accepted" or from "Bob" is editing to "Mary" is editing. I have an "Updated" column but I have to change it myself.

What I would like is an "update" column that changed the date automatically every time I make a change. That is, no matter which field I change for a project (the title, the author, the assignment date) the update column automatically updates.

Is this possible? If so, how? Thanks in advance to any help.

MarkShnier · Accepted Answer

Well, let's start with the easiest solution and work from there. There's already a built-in field called date modified. It will show you the date and time that the record was last modified.

if you don't wanna see the time of day, then you can set the field properties for that field not to show the time. As an assign, you can also show the field class modified by, and that would let you know who made the last update.

MarkShnierYou · Answer

Well, let's start with the easiest solution and work from there. There's already a built-in field called date modified. It will show you the date and time that the record was last modified.

if you don't wanna see the time of day, then you can set the field properties for that field not to show the time. As an assign, you can also show the field class modified by, and that would let you know who made the last update.

Sign up

Login to the community