NOW() returns the current date and time, so not sure what you're struggling with there in terms of being able to find the time.
It sounds to me like you first need to create a calculated field to combine the creation date and time. Something like this will work assuming your CreationDate is a date and the CreationTime is also a datetime field; datetime(str([Creation Date]) + " " + right(str([Creation Time]),8))
Once you have this 'combinedtime' you can create another calculated field like;
datediff('hour',combinedtime,now()) <= (10*24)
This will evaluate to true if the difference in hours between the combined time and now() is less than or equal to 240 hours (10 days * 24 hours)
Drag this field onto your filter shelf, set it to true, then drag your creation time onto columns and you have your table.
Find my approach as reference below and stored in attached workbook version 9.3
Last 10 days: if DATEDIFF('day',[date],today())>=0 and DATEDIFF('day',[date],today())<=9 then [date] END
Last 10 days.twbx 25.4 KB
Thanks Tom, i think i have not explained correctly.
so each day 100 orders are created, as of 9AM we get 30 orders. so i want to know as of 9AM what was created today vs last 10 days.
i am able to figure out another option. i created new field called currenttime
INT(STR(DATEPART('hour',now()))+ STR(DATEPART('minute',NOW()))+ STR(DATEPART('second',now())))
and then i converted my created time string field into HHMMSS_createdtime calculated field
then dragged the HHMMSS field in the filter
and added the formula
[CurrentTime] >= [HHMMSS_createdtime]