Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Ived made an variable called vDateToday which is based on Today()
This gives me the date today.
Now i want en expression to select on todays data - but i can get it to work.
I have have a listbox with todays date in i can easily select todays data only
my expression are as follow:
=sum({<Date_Clean={$(=(vDateToday))}, ReportDayEntry.Type={'EntryDownloadVisit'}>} ReportDayEntry.Antal)
But it returns 0
Date_Clean is in format YYYY-MM-DD
And my variable format is also YYYY-MM-DD
If i write this
=sum({<Date_Clean={'2013-02-07'}, ReportDayEntry.Type={'EntryDownloadVisit'}>} ReportDayEntry.Antal)
it works perfectly - but i dont want it hardcoded.
Try this:
sum({<Date_Clean={'$(vDateToday)'}, ReportDayEntry.Type={'EntryDownloadVisit'}>} ReportDayEntry.Antal)
Try max
sum({<Date_Clean={$(=Max(Date_Clean))}, ReportDayEntry.Type={'EntryDownloadVisit'}>} ReportDayEntry.Antal)
or
sum({<Date_Clean={$(=Date(Today(),'YYYY-MM-DD'))}, ReportDayEntry.Type={'EntryDownloadVisit'}>} ReportDayEntry.Antal)
hope this helps
non of the two statement works
if possible share sample file
file is shared now - hope you can help
Try this:
sum({<Date_Clean={'$(vDateToday)'}, ReportDayEntry.Type={'EntryDownloadVisit'}>} ReportDayEntry.Antal)
That worked for me! Thanx ! How come this work, and the other expression doesnt??? Is it due to its a string??
Do you know how i can get 7 days back? So i can show in a chart the last 7 days?
can i make a variable that takes 7 days back (not the 31, but the 7,6,5,4,3,2,1)
u posted something, but it only takes from the 31 of january?