9 Replies Latest reply: Feb 7, 2013 3:59 PM by Thomas Jensen RSS

    get todays data



      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.