on 07-10-2012 6:12 AM
Hi Experts,
I am facing an issue while getting a default value in date filter which is 30 days before the current date.
I have done the following things in order to solve that:
1. In Filter Prompts tab, I have added CREATED_AT date filter where I have given <%Today%> token in Default Value field. So when we preview the query we can see by default the current date is getting populated in the CREATED_AT filter.
2. I have Changed the default value to "<%TODAY%> - 30".So I m getting an error.
3. I have used functions like FCI_DATEDIFF etc.,but that default value field is not accepting any functions.It is showing an error.
Can anyone pls help me out in solving this issue. Any help would be appreciated.
Thanks & Regards,
vignesh
Hi Vignesh,
I have a similar requirement to you and have solved it by using the same method as in the standard system query called FCI-RecentlyExpiredAgreements.
To get all projects with a base date within the last 180 days to be shown in my report by default I used the following code in my query:
A.BASE_DATE_DATE <= <%TS%> AND
(
<%SCHEMA%>.FCI_DATEDIFF( A.BASE_DATE_DATE, <%TS%>, 16) <= ?
)
In my filter I have data type Integer and the default value set to 180.
I hope this helps.
Regards
Dan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.