Hi.
I am supposed to create a Button for Customer which can auto refresh the entire DATA based on the present DAY.
Something like stated in the picture below.
This can easily be done with the NOW() function but now the issues is the data should be less on day from the present Day. i.e. in this case 28th August 2016.
How to achieve this?
how to get a date less than the present Date.
So I found the Answer Myself!!!
Step I: Create a Now() field from the data.This would auto populate today's Date.
Step II: Create a new calcualted Item.Using Treat as fucntion and Datepart function change the Now data field to Number and Subtract the number of days you want from it as shown below:
Step III: USing this calucated Item crete another calculated item and again use this numeric data to chage into date itme for this time as shown below:
So I found the Answer Myself!!!
Step I: Create a Now() field from the data.This would auto populate today's Date.
Step II: Create a new calcualted Item.Using Treat as fucntion and Datepart function change the Now data field to Number and Subtract the number of days you want from it as shown below:
Step III: USing this calucated Item crete another calculated item and again use this numeric data to chage into date itme for this time as shown below:
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.