Splitting down the day

[#1]

I am loading a sales table that has separate date and time columns.

In my chart I want an expression that brings through the data based on the date AND time up to the minute of the current time.

e.g. if the time is 15:00 I want all the data up to and including this time on the date I have already specified below.

This is the expression I am using to identify the correct previous day (it is effectively the equivalent sales day from the previous year) but I need to also include the time criteria as above.

Sum({<[o-date]={'$(=Date(Today()-363))'}>}[NetSales])

o-date is the date field  (yyyy-mm-dd)

NetSales is the sales value

ainput-time is the entry time (hh:mm)

Thanks for all your help.

[swuehl]

Yes the fields are filtered independently.

o-date will be filtered to a single day 363 days ago, and ainput-time to values below the current time.

The result should be (as of now) 2014-08-22, 00:00:00 to 22:44:00

[#3]

I had to tackle this a little differently by loading the date and time separately as numeric values and comparing them against the current date and time in the same manner.

I'm not quite sure why I could not do this using date and time but it worked with no additional overhead.

Thanks for all help !