Format date values in a cache query filter
1 April, 2014
Hi,
We have 2 cache dependent filters in our report :- 'Start Month' & 'End Month'. End Month is dependent on 'Start Month' such that 'End Month' cannot be greater than 11 months from 'Start Month'. We have accomplished this using custom queries.
Now, our dates are displayed as '01/01/2013', '01/02/2013' .... ,however, we would like to remove the day part and display only something like '01/2013' , '02/2013' ... (Since the day part is irrelevant)
Is this possible ?
Screenshot of the report -
Thanks
We have 2 cache dependent filters in our report :- 'Start Month' & 'End Month'. End Month is dependent on 'Start Month' such that 'End Month' cannot be greater than 11 months from 'Start Month'. We have accomplished this using custom queries.
Now, our dates are displayed as '01/01/2013', '01/02/2013' .... ,however, we would like to remove the day part and display only something like '01/2013' , '02/2013' ... (Since the day part is irrelevant)
Is this possible ?
Screenshot of the report -
Thanks
Hi Asif,
All you need to do is change the format of the Filter field at the View Level
Below i formatted the End Month to display MonthName and Year.
This inturn will format the filter field to the desired format.
Hope this helps you to achieve what you are trying to do.
Regards,
Stephen
All you need to do is change the format of the Filter field at the View Level
Below i formatted the End Month to display MonthName and Year.
This inturn will format the filter field to the desired format.
Hope this helps you to achieve what you are trying to do.
Regards,
Stephen
Hi,
We are using YF 6.3. We have changed the date format in the view, as shown in the screenshot. However it is not changing the format in the filters, as shown. What could be the reason?
Regards
Nikhil
We are using YF 6.3. We have changed the date format in the view, as shown in the screenshot. However it is not changing the format in the filters, as shown. What could be the reason?
Regards
Nikhil
Hi Nikhil,
I have tested this on my installation of Yellowfin 6.3 and found that the date format applied at the view-level only affects the report filter if the filter format has been set to cached values instead of user prompt.
I hope that bit of information helps you, please let us if there are any further questions.
regards,
Dave
I have tested this on my installation of Yellowfin 6.3 and found that the date format applied at the view-level only affects the report filter if the filter format has been set to cached values instead of user prompt.
I hope that bit of information helps you, please let us if there are any further questions.
regards,
Dave
Hi David,
In reference to your statement above "the date format applied at the view-level only affects the report filter if the filter format has been set to cached values instead of user prompt", is there any way to have the same format for report filter which is a User prompt filter ?
Thanks,
Eku
In reference to your statement above "the date format applied at the view-level only affects the report filter if the filter format has been set to cached values instead of user prompt", is there any way to have the same format for report filter which is a User prompt filter ?
Thanks,
Eku
Hi Eku,
The user prompt date filter takes it format settings from the user regional settings.
E.g.
DD/MM/YYYY
YYYY/MM/DD
Because it's a date selector, you cannot have it displayed as the month name or anything like that.
Sorry for the bad news.
Regards,
David
The user prompt date filter takes it format settings from the user regional settings.
E.g.
DD/MM/YYYY
YYYY/MM/DD
Because it's a date selector, you cannot have it displayed as the month name or anything like that.
Sorry for the bad news.
Regards,
David