I have these two parameters in my MS SQL stored procedure:
@StartDate datetime,
@EndDate datetime
If I just insert one of the parameters to the report it looks like this: 6/2/2005 12:00:00AM
The format is System Default Short Format.
What I want is to be able to use just the date part.
I tried this: left({@StartDate}, 2)
and got 20 (I expected 6 or 06 or even 6/).
I thought that meant the year was really on the left but when I put in left({@StartDate}, 4) I got 20-A.
How do I get the day, month, and/or year for my reports?
Thank you -
@StartDate datetime,
@EndDate datetime
If I just insert one of the parameters to the report it looks like this: 6/2/2005 12:00:00AM
The format is System Default Short Format.
What I want is to be able to use just the date part.
I tried this: left({@StartDate}, 2)
and got 20 (I expected 6 or 06 or even 6/).
I thought that meant the year was really on the left but when I put in left({@StartDate}, 4) I got 20-A.
How do I get the day, month, and/or year for my reports?
Thank you -