I have a report that is created off of date prompts. Unfortunately those date prompts are a date and a timestamp. I want to show just the date prompt. The dates are prompted as Begin Date and End date I want to be able to show both. Below is an example of what I have on the report.
1/24/2004 12:00 AM - 1/27/2004 12:00 AM
my goal is to get the report to show
1/24/2004 - 1/27/2004
I have created a variable using the ToDate function but it has not worked, everytime I bring it into the report I get
# error. Below is my variable statment.
=ToDate(UserResponse ("Query 1 with AIS-MQR1" , "Type Begin Date") ,"mm-dd-yyyy")
I'm not sure whats causing the error, but I would really appreciate any help possible,
Thanks in advance
1/24/2004 12:00 AM - 1/27/2004 12:00 AM
my goal is to get the report to show
1/24/2004 - 1/27/2004
I have created a variable using the ToDate function but it has not worked, everytime I bring it into the report I get
# error. Below is my variable statment.
=ToDate(UserResponse ("Query 1 with AIS-MQR1" , "Type Begin Date") ,"mm-dd-yyyy")
I'm not sure whats causing the error, but I would really appreciate any help possible,
Thanks in advance