cancel
Showing results for 
Search instead for 
Did you mean: 

From & To Date Function

nsandee
Participant
0 Kudos


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

Accepted Solutions (1)

Accepted Solutions (1)

former_member205840
Active Contributor
0 Kudos

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

DellSC
Active Contributor
0 Kudos

And in order to do this you have to manually edit the selection formula in the Select Expert- you won't be able to select the SQL Expression as values using just the "standard" Select Expert functionality.

-Dell

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

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