on 09-11-2014 11:30 AM
Hello All,
I have date column in DB as '2012-11-09' and i have converted the date format by creating a variable "Week Begining" and used this formula " DATETRUNC('week',[Chrg Week], 'monday') "
Now, i have to use to use "Week Begining" as From & To for selection of the dates
How can i use?
Best Regards
Sandeep
Hi Sandeep,
If you place your formula in the report, if it is retrieving data then you can use this in Record selection formula to filter records.
{date} >=(@week Begining} and {date} <=(@week Begining}
This will give you only one day data.
If this is what you are expecting then explain more on this with example(s)
Thanks
Sastry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sandeep,
Is this a SQL Expression field : DATETRUNC('week',[Chrg Week], 'monday')?
Could you please explain : "Now, i have to use to use "Week Begining" as From & To for selection of the dates" with an example?
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.