I have a string with date parameters. Those date contains Hours/Minute/Second and i juste want the date without the time. So i have tried this:
=Format(Parameters!StartDate.Value, "d") & " to" & Format(Parameters!EndDate.Value, "d")
But this return me:
d to d
What i want is something like this 2000-01-01 to 2006-01-01
How can i do this ?
Thanks
What are the data types for parameters StartDate and EndDate? Can you make sure they are of datetime type, not string?|||
Thank for your answer. You're right. Those dates come from parameters so they were in string... i've put a CDATE before the FORMAT and now it's working fine.
Thanks !
No comments:
Post a Comment