Does anybody knows if I can create a rule (in SD4.5 SP18) that set a date custom field with the value “the next Tuesday” in date format?, that is to say, if today it's 04/01/2007 I want that the rule set that custom field with the value 09/01/2007 (the next Tuesday).
You'd better do that with an external tool because though it can be done is SD it's very clumsy.
The General Idea: 1. Create a custom number field 2. Set custom field to have the value $D$ (this returns the current day of the week, 1-Sun to 7-Sat 3. Create seven ui rules for each value of the custom number to add a fixed timespan in days in the custom date field.
For example if custom number=5 (Thursday) then add 5 days to your date field.
I think you can modify George'e idea (whic as ever is a great one) by using a custom TEXT field. Set this as he suggests to have the value $D$. Then create his seven ui rules for each value of the custom text to add a fixed timespan in days in the custom date field.