I’m trying to recreate the functionality of a ChangeTimestamp column so the user can edit the DateTime if required. An option not allowed on ChangeTimestamp columns. Here are the columns involved:
[PF1] = ENUM with one option - “Done”
[Res1PicTS] = DateTime column with following options:
Initial Value
IF([_THISROW_BEFORE].[PF1]<>[_THISROW_AFTER].[PF1],Now(),[Res1PicTS])
Reset If
[_THISROW_BEFORE].[PF1]<>[_THISROW_AFTER].[PF1]
So it should update [Res1PicTS] with Now() if [PF1] changes.
The weird thing is this works only when changing [PF1] from “Done” to “” but not the other way around. If you set [PF1] to “Done” then [Res1PicTS] does not get updated to Now(). Even tried changing the Intial Value to just Now(), with the same results. So it seem the Reset IF code doesn’t work when changing from blank to not blank. But I can’t see why not.
Any ideas?
LinkedIn
Twitter
