Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
How can i get all records for till date using set analysis? for ex today(25-Apr-2016) i wanna all records for the month using set analysis
Try this May be:
{<DateField = {"$(='<=' & Date(Today(), 'DateFieldFormatHere'))"}>}
Is this issue resolved Gopi?
Hi,
If the date is month wise , you can use this .. please let me know if your DATA is in datewise .....
LOAD * INLINE
[
date, sales
march, 5000
march, 6555
april, 555
april, 77
april, 8888
april, 1200
];
For Expression :
sum({1<date={april}>} sales)
Hi Allu,
Thanks for concern about this issue, this one solved. But my interview asked me today date without any date mention. How do you do without knowing the exact date???
Hi Sunny,
No not yet...
Try this May be:
{<DateField = {"$(='<=' & Date(Today(), 'DateFieldFormatHere'))"}>}
Ooh Sunny,
Thank you so much it works well.....
Thanks...
If my response proved helped you then please mark it as the correct answer. This way people in future will find it useful as well when they land on this thread