Is there perhaps not an option to have ChangeTimeStamp reflect a Date instead of Date & Time without needing a virtual column to reflect only the Date of the ChangeTimeStamp field.
Basically, I want to be able to record the Date (Not Date & Time) each time a change another field in the row.
From column [Date] go to / update behavior / click on the box Reset on edit?
โ
I not sure if you are understanding my question.
I am looking for the same functionality as the DateTimeStamp column type that will instead capture the Date and Not Date & Time (i.e. NOW) when there are changes in another field I select.
You can use this Function NOW() inside column [Date]
And from Edit if use this
[_Thisrow_Before].[Column_A]<>[Column_A]
It will work if you have any change only in Column_A
If not this what you looking about then im sorry for not knowing your request
How do I set it up to do this, but just in date and not date&time.
[_Thisrow_Before].[Local product Status]<>[Local product Status]
Am I using this expression in Editable? or Reset on edit? or both
Use it in Editable
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |