Creating simlified rep by rule

[daveykbelgium]

Hi

I'm using Wildfire2 and Intralink 3.3

I want to create a simplified rep by rule. The condition I'm trying to define is to include a master rep of all parts that were submitted to the Intralink commonspace after a certain date.

In the master rep of the assembly I'm creating a new simplified rep, using the following rule settings;
expression/string/symbol (proi_created_on)/comparison (is greater than)/value (8/20/2006 00:00:00 )

When I preview results, I see nothing.

My suspicion is that because the parameter I'm using is a string and not a number, the "greater than" comparison can't work.

Another anomaly is that when I look in the Intralink, the “created on” format is as follows; 8/14/2006 5:23 PM. When I use the pull down list of values when I'm trying to create my rule, the format is as follows; 8/14/2006 17:14:20

Can any Intralink or system administrators give me some guidance, or an alternative methodology?

Thanks in advance

Dave

 

[3dlogix]

You can make a set of relations that compares the date string. Try the month first, and then the day and year.

A simplified example would be:

If date string is 08202006, then compare the month (first 2 values), then the day (3rd and 4th values) and so on for the year.

http://www.sprdesign.com

http://www.3dlogix.com