[chaley]

Originally Posted by tarisea

Chaley that's perfect.

Just purely out of curiosity is it possible to take this one step further?

#column1 - numeric value
#column2 - fixed set of values, but only 1 is relevant here
#column3 - date

Is it possible to:

If #column1 >1 AND #column2=blue then {#column3:format_date(MMyy)} otherwise blank

Just pushing my luck. Tired of doing things manually.

Thanks

program: cmp(
	field('#column1'), 
	1, 
	'', 
	'', 
	strcmp(
		field('#column2'), 
		'blue', 
		'',
		format_date(field('#column3'), 'MMyy'), 
		''
		))