Monday, February 20, 2012

Problem with date format

Hi!

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