We are trying to configure the Data partition of one of the roles with which the #SDM tool
is used. In this case the data partition of the table is being configured is Workflow_Task
and the type of restriction is Update with the following condition:
(chg.sched_start_date > chgalg.time_stamp)
It is desired that if the start date of an order change is greater than the current date,
a message will be displayed that cannot update or modify the change order because the date is
already expired. In this case we tried to do the test with a change order where the start
date was greater or less than the current time and never showed the message, so we would
like to know what the behavior is for this type of restriction since it does not comply
with what is being established in the condition.

The version of Service Desk Manager is 14.

Thanks for the help.

Hey Carlos,

Checkout couple of threads here that may help here:  Data Partition - Compare Dates r12.9   and data partition constraint - use of date's 

_R

The first link i don´t have permission to look it, this is the message I get from the link:

No autorizado

Este lugar o contenido no existe o su acceso está limitado. Si piensa que esto es un error, contacte al administrador o a la persona que lo dirigió aquí.

it says: "Not authorize. This place or content does not exist or its access is limited. If you think this is a mistake, contact the administrator or the person who directed you here."

¿ Could you please copy the information here in order to see what it is about ?

With the second link i'm able to see it. I hope this link help me with this subject.

Thanks a lot

CR

CR, you can try

chg.sched_start_date > EndAtTime(PAST_HOUR)

Thanks _Chi

Carlos..........

Did the example that Chi_Chen provide work?

If so, please mark Chi's answer as correct so that this thread can be closed.

The answer that give Chi about my question doesn´t complete the requirement because it doesn´t take account very well the conditions given on the partitiomn data.

Hi Carlos,

You may also find another community thread that talks about the date fields in data partition.

https://communities.ca.com/message/242021343-re-data-partition-constraint-use-of-dates?commentID=242021343#comment-242021343

Hi Carlos,

It looks like the summary of the community thread provided in my earlier activity is revolving around the similar concept of what Chi mentioned earlier. Hope you are able to get this working as per your requirement?

Keep us posted with your progress.