Need your help.
I have a table with columns :
Transaction date [Trx date] type date
Verification date [Verification date] type datetime
Verified by [Verified by] type useremail
Transaction date can be input from the range of the last transaction that had been verified, until current date.
So I put the expressions as below
For Transaction date [Trx date]
Valid if :
And([Trx date]<=Now(),[Trx date]>date(max(select(table name[Trx date],isnotblank([Verification date])))))
Invalid Value Error : The transaction date is beyond today’s date or has been verified
For Verification Date
Valid if :
[_thisrow].[Verification Date]>=[_thisrow].[Trx date]
Invalid Value Error : The verification date must be after the transaction date
I create an Action : Set the value of some columns in this row ;
Verfication date = now()
Verified by = useremail()
Current data :
Trx date : 13 Mar ; Not verified
Trx date : 12 Mar ; Not verified
Trx date : 10 Mar ; Not verified
Trx date : 09 Mar ; Verified date : 14 Mar
Trx date : 08 Mar ; Verified date : 09 Mar
Trx date : 16 Feb ; Verified date : 15 Mar
Problem is when I click Action button to verify the transaction of date 10 - 13 Mar, error message come out : The transaction date is beyond today’s date or has been verified
I still can input any date from 10 Mar to current for Trx date, no invalid value error message come out
Why the Action button cannot just set the value of [Verification date] and [Verfied by] ?
And as I know the Action has nothing to do with the [Trx date]
Could anybody tell me what’s wrong and the solution?