Data Restriction On Time & Date

[Anonymous]

Hi,

I have a scenario where data consists of Date & Time. Now If User wants to see report then it should show values from Yesterday 6.00AM to Today 6.00 AM.Please look into it.

Thanks in Advance

[alexandros17]

When you open the document use the trigger OnOpen (settings -> document properties -> triggers -> onopen -> add -> select in field then write your date time field name and in the lower box write the condition

[Anonymous]

Thanx Alessandro.......Could you please elaborate it more....

[#4]

Hi Himanshu,

What Alexandro meant was goto Document Properties >> refer screenshot below and add the value in search string.

[Anonymous]

Hi Krishna,

I appreciate your effort....But seriously I am not getting how to show data from yesterday 6.00AM to Today 6.00AM 

[#6]

Can you post sample .qvw with relevant data so that I can help you on this issue.

[Anonymous]

In the screenshot from HareKrishna enter the search string:

= '>=' & timestamp(today()-1/4) & '<=' & timestamp(today()+3/4)

Edit:  The example above is 6 PM to 6 PM.  For AM:

= '>=' & timestamp(today()-3/4) & '<=' & timestamp(today()+1/4)

[Anonymous]

Here I have attached sample data...Now suppose today 16Feb'15....In dashboard it should show data from 15Feb 6.00 AM to 16Feb 6.00AM .....In this manner...Did You get my point????

[maxgro · Accepted solution]

PFA

test:

Load

  *,

  Date + Time as DateTime;

LOAD userId,

    Date,

    Time

FROM Test.xls

(biff, embedded labels, table is Sheet1$);

search string on field DateTime

= '>=' & (today()-14-1/4) & '<=' & (today()-14+3/4)

when you have record for today and yesterday in your excel, remove -14

[Anonymous]

Hi Massimo,

Thanks a  Lot......I got correct answer...Could you please explain the logic???