Security rule to compare system date to a stored date

 0 Replies
 0 Subscribed to this topic
 15 Subscribed to this forum
Sort:
Author
Messages
ThomasT
Advanced Member
Posts: 27
Advanced Member
    I want to write a rule in Security Administrator which compares the current system date to the HIRE DATE  from "EMPLOYEE" table.

    I've tried various combinations of the rule functions but cannot get it. I know that the system date is stored in one format and the stored dates within the tables is in another format.

    Does anyone have any example of a rule they have used to write to compare the system date to a stored date (within any table??)  T
    Thank you ,
    Thomas