on 04-28-2016 11:04 AM
Hi,
I want to show last one month data from current date.
I have a date field "LOGGEDON"
I want to filter it in projection , so that the filtered data is only passed to upper level.
What are the ways to do it?
Kindly suggest.
Regards
Vaibhav
Vaibhav,
I think I got your problem,
Kindly create a Calculated column for longdate("LOGGEDON") as CC1
then you already has Calculated created column of yours with (adddays(now(),-30)) as CC2
then compare the Expression , you will not get the error.
Regards,
Chandan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chandan,
This time i am not getting any error and created two calculated columns:
1) L_Date:
"LOGGEDON"
2) Add_Date:
adddays(now(),-30)
Created an Expression where:
"L_Date"="Add_Date"
this time not getting any error, but while previewing the data it showing empty result, No Rows Retrieved.
Even i tried for past 60 days but no result. Although the data is there.
What could be the reason?
plz suggest
Regards
Vaibhav
Vaibhav,
try add_months(current_date, -1)
here is the official documentation for the add_months function
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Adding to Sergio's points, but if you still trying to get the filter to only last 30 days (fixed). Whatever you have done is correct, it is just that in the filter expression editor, you must be comparing like this:
LOGGEDON = Date_Filter
Just ensure the data types of both these columns are same.
Regards,
Krishna Tangudu
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
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.