how can I format a Prompt Date?

[Lee73]

Hi everybody,

I have this little issue:

having a Date prompt like:

UserResponse ("Query 1 with UnvName" , "1. Insert a date&quot

the value shown in the report is for ex. "01/02/2004 00.00.00"
how can I truncate the above date to "01/02/2004" ?

Since now I cannot understand if the result of the Prompt Date is a Char or a Date...

Does anyone already faced this issue?

Thanks
Ciao

Sabry

 

[nimmy99]

How about formatting the cell?

 

[sh4kil]

Use FormatDate(UserResponse ("Query 1 with UnvName" , "1. Insert a date&quot,"dd/mm/yyyy&quot or "mm/dd/yyyy" depending on your date format

 

[norty303]

The result of your query in the dp will always be the same type as in the database. If you want to use the userresponse in a variable then it is always a CHAR type and will need to be converted using:

formatdate(todate(,),)

if you want to use it in date calculations etc