Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
How to write set analysis for between 3 months data ,
what is diff b/w today() and today()-1 it get number or date.
interview questions?
Hi Siva,
2nd answer is Number only .
Hope helps
1) Sum({<Month = {"$(=AddMonths(Month, -3))"}>}Sales)
This Will give last 3 months of Sales
2) Today() Will give Today's date of your Computer calendar & Today()-1 is Yesterdays date of your computer calendar (It returns Date for Today and Number for Today-1)
hi,
today() is going to print today date like 30-11-2016
today()-1 is going to print number,if you apply date(today()-1) it will brings the yesterday date.
It will helps you to get 3 months data
sum({<Your Date filed={">=$(=AddMonths(Today(),-3)) <=$(=Today())"}>}Sales)
this expression brings data from 3 months back to today.
It'll calculate the sum of Hours where Data > 2016-08-30:
=SUM(
{<
Date={">$(=Date(AddMonths(today(),-3), 'DD/MM/YYYY'))"}
>}
Hour)
The date is a dual functions. It contains numeric and date values.
Thanks Anil for your quick replay,
Could you help me on set analysis , i have lot of doubts , if you have time