database date format

[Guest_imported]

i want to equate a date attribute to the current date and display the rows. the problem is the date format displayed in microstrategy is not compatible with my database format. making a prompt and selecting also doesn't work. so i created a filter with date attribute id value exactly custom value where i used to ApplySimple function.

"ApplySimple("cast(#0 as date format "yyyymmdd&quot",date)" where date will give the current date. my backend database is teradata and my date field is in that format only. when i execute the report it says character string conversion failed. can anyone had experience similar to this. please help.

thanks

 

[nlim]

can you create a custom filter instead on the data attribute that looks something like "date@desc = sysdate" (substitute e teradata specific syntax)...

 

[fukudahs]

Josent,
Try to exchange the inner double (&quot to a single one (')
and the comma (,) to dot comma (.
ApplySimple("cast(#0 as date format 'yyyymmdd')";date)