Security rule to compare system date to a stored date

 0 Replies
 0 Subscribed to this topic
 16 Subscribed to this forum
Sort:
Author
Messages
ThomasT
Advanced Member Send Private Message
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