How to keep a date stamp stable

This is odd. I have a series of Actions in which an image is generated, the current date is written to a ‘date’ column, and the count increments by 1. The intention is to count how many times within each day a user performs a task.

What’s odd is that yesterday (Dec 11), I generated 5 images. Those were logged with yesterday’s date in the data editor.
Today, Dec 12, I look at the data editor and it claims I generated 5 images today.
I haven’t generated any images today.
Screenshot 2023-12-12 at 12.12.00 PM

It appears that the ‘date’ column is showing today’s date and not the date on which I performed the action.

Does anyone see how to resolve this so that the data maintains the date on which an action was performed?

I might have more questions, but how do you “reset” this? It’s always just the use of the current day?

Right now, I only care about how many uses per day. It can reset each evening as far as I am concerned. The important bit is to have the count (increment) return to zero each day.

Given that it’s a non-computed column, the only way that can happen is with an action. Maintaining counters in this way is always problematic and subject to all sorts of things going wrong.

I did offer you an alternative solution to this problem a day or two ago - no interest in that?

1 Like

Thank you for offering the other option. I tried it but got stuck in the same problem in that the date changed to match current date but retained the previous count. I will continue to work through your previous suggestion to see if I can find my error.
Thank you

That sounds like you may not have configured the Query column correctly. If you can’t get it working, show me what you’ve done and I’ll guide you.

It would seem that I missed two words in your original suggestion:-(
It works now.
Thank you :bowing_woman:

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.