Can this be done??? 1

[mstrgrl]

I have an attribute which is Oracle datetime format. We need to truncate the time off the date (TRUNC(opendate) ); however, in the documentation I'm seeing for MSTR the TRUNC only works on a number data type.

Suggestions? Thanks!

 

[entaroadun]

If you just want to change how the attribute elements display, just change the form format type to Date. You don't need to do any pass-thru SQL.

 

[spod]

You can use an applysimple in the attribute editor.

Something like

applysimple("trunc((#0), 'MM/DD/YYYY')" , [opendate])

 

[Rambo2292468]

Hi All
Please tell me if we can use max function while defining the attribute ,I tried using and it fails .

requiremnet : My requirement is to get max (Column1) as a value from the attribute how can I achieve this