You need to sign in to do that
Don't have an account?
Sourav P
Issue in comparing a Date/time field with a particular time value
Hi,
I have a wf rule where, contract activated field ( date/time) need to be less than the local time 16.30 ( 24 hr format). I am trying the below, but i have the issue in comparing the minutes,
My formula as below,
AND( IF(VALUE(MID(TEXT(Contract.ActivatedDate+(7/24)), 12, 2)) > 16, true, false),IF(VALUE(MID(TEXT(Contract.ActivatedDate+(7/24)), 15, 2)) > 30, true, false) )
Now, Hour is OK, but certainly i cant put AND for minutes neither OR. As 17.20 is also greater than 16.30, So anyone plz suggest how can i modify teh above formula to include the minute one ? Thanks
I have a wf rule where, contract activated field ( date/time) need to be less than the local time 16.30 ( 24 hr format). I am trying the below, but i have the issue in comparing the minutes,
My formula as below,
AND( IF(VALUE(MID(TEXT(Contract.ActivatedDate+(7/24)), 12, 2)) > 16, true, false),IF(VALUE(MID(TEXT(Contract.ActivatedDate+(7/24)), 15, 2)) > 30, true, false) )
Now, Hour is OK, but certainly i cant put AND for minutes neither OR. As 17.20 is also greater than 16.30, So anyone plz suggest how can i modify teh above formula to include the minute one ? Thanks