Current date data
1.Is this possible in SF, I want past 2months data from the system current date when i open my dxp.
2. How can i show automatically current date data in my dxp.
Please do reply if anybody is aware of this.
If you are using Information Links, you might want to test using a Filter element (for the column containing the dates) for this. What syntax to use will depend on your data source so you should refer to the documentation for that for the exact SQL syntax.
Here's an example of how you could e.g. filter the data to only return data from ~ the last 2 months (60 days) on SQL Server
DATEDIFF(day, %1, GETDATE()) < 60
Thanks Fredrik for your reply.But the problem is differnt out here :-
a)If you put DATEDIFF(day, %1, GETDATE()) < 60 in information link then always,2month data will be loaded.But wat we are looking for is,that when user loging in webplayer or client,By default 2 month range is slelected and if user clicks on Reset filters then he can see the whole date range...
Hello Tibco Enthu,
As per my understaning Akrati is looking for the following things:-
a) When she open the .Dxp file the Date filter should (By Default) show the data of Past 2
Months data from the current date always.But if she want to see the complete date range
data then this should also be visible.In Simple words,She want default filters with time range of 2
b) What expression should be written in information link so that only data till current date
should be loaded always ,,,,