I have a parameter whioch select Month, Week or Day. I want to convert a date field dependent on the parameter selection.
ie
if month the date format is Nov 07
if Week then the first day of the week is shown ie 19 Nov 07
id day is selected then just the date is shown ie 21 Nov 07
the formula is
if {?Chart}='Month' then ******
else if {?Chart}='Week' then ******
else date({Incident_Date})
what is the formula for '******'?
It needs to return a date format as it is then sorted in date order.
thanks in anticipation