4 Replies Latest reply: Jan 8, 2015 8:27 AM by Neil Deeley RSS

    Today() variable and time stamp issue

    Neil Deeley

      Hi there,


      I'm pulling date from Access to create a bar chart.


      I have created a variable in my load script which pulls back today:


      LET vTodayTY = Today();


      ...so I can pull out all completed records from the start of the year to this date in the measure:


      sum({$<ChargeableYN={'1'},CompletionDate={">=$(#vFirstDayThisFinancialYear)<=$(#vTodayTY)"}>} [AmountCharged])


      My Completion Date is pulled out of the Access DB like this:


      date(CompletionDate ,'DD/MM/YYYY') as CompletionDate


      I have one record with a CompletionDate of 08/01/2015 10:35:42. This record is not included in my bar chart using the start of the year and the Today() variable. If I change the CompletionDate to the 07/01/2015 it is included.


      Is there a timestamp I'm not removing that is causing this record not to be used as part of the calculation?