remove time stamp from date
Had start date and end date as prompt in webi report and showing same date value in report header using UserResponse function but it is showing time with date, and in report both columns are showing in dd/mm/yyyy format, have tried using FormatDate(UserResponse("Start Date:"); "dd mmm yyyy"), it is giving an error
" The expression/sub-expression uses an invalid data type"
please tell me what is wrong in the formula
thanks & regards