How to manually change the value of the "ChangeTimestamp" column data type?

[sayan1]

Hello!

I have a column named "Status." When a user changes it, the value of the "StatusChangeTime" field is automatically set.

The type of the "StatusChangeTime" field is "ChangeTimestamp."

However, sometimes it's necessary for the user to manually change the date of the "StatusChangeTime" field.

To facilitate this, I've created a page where the user can select the status and set the date.

Everything works fine, but the "StatusChangeTime" field isn't displaying.

My question is as follows:

How can I manually change the date of the "StatusChangeTime" field both by user input and automatically when the "Status" parameter changes?

Thank you in advance for your help!

[Suvrutt_Gurjar · Accepted solution]

I believe with the "ChangeTimeStamp" type column you may not be able to give the editing option to the user.

Instead you could try below. 

1. Please make the [StatusChangeTime] column a datetime type.

2. Please have initial value of this column as NOW()

3. In the reset on edit setting , add an expression of 

   OR([_THISROW_BEFORE].[Status]<>[Status],
ISBLANK([_THISROW_BEFORE].[Status])
)

The above should do the desired operation you wish.

[sayan1]

Thank you very much! I will try as soon as possible

[sayan1]

Thank you! It's work great! 

[Suvrutt_Gurjar]

You are welcome. Thank you for the update. Good to know it works per your requirement. Please test well.