get todays data

[#1]

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.

[SunilChauhan]

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

[#3]

non of the two statement works

[SunilChauhan]

if possible share sample file

[#5]

file is shared now - hope you can help

[Gysbert_Wassenaar · Accepted solution]

Try this:

sum({<Date_Clean={'$(vDateToday)'}, ReportDayEntry.Type={'EntryDownloadVisit'}>} ReportDayEntry.Antal)

[#7]

That worked for me! Thanx ! How come this work, and the other expression doesnt??? Is it due to its a string??

[#8]

Do you know how i can get 7 days back? So i can show in a chart the last 7 days?

[#9]

can i make a variable that takes 7 days back (not the 31, but the 7,6,5,4,3,2,1)

[#10]

u posted something, but it only takes from the 31 of january?