Jeanne Boyarsky wrote:Or are you asking how to do a query to get dates less than 3 days away? If so, what database are you using? Have you looked at the date functions for that database?
Dieter Quickfend wrote:it's not really clear to me what you want to do.
If you want to test whether String type equals either "Pro" or "Glob" you could use:
What this will do is it will compare whether your String, type, equals either "Pro" or "Glob", and if it equals one of these, it will return "Prof" and assign it to the String outcome, otherwise it will return "Tech" and assign that to the String outcome.
If that's not what you want, you should clarify your query.