I date/time

[mila3746]

How to set the Date prompt based on a retrieved date/time from the database.

I had created a date prompt and created '[NERS].[DOCUMENT].[CREATEDATE]=?Parameter1?'

but when i cast_date [[NERS].[DOCUMENT].[CREATEDATE]=?Parameter1?]..

it was throwing erroe.

in my datebase i have createddate as date/time,but now i needs to filter it up as date only.

pls help me.

 

[qberta01]

I have encountered this problem several times. Usually I play around with cast...cast one or the other as date or even try varchar..until it works.