Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
rishikeshtiwari
Creator
Creator

How to calculate Comparison of times

Hi Guys,

I have one requirement.

The Date should default selected to yesterday's date as of 10AM of current day. 

Before 10 AM the selected Date should be the day before yesterday.Current Date is capture by OS date.

Suppose if Today is 24 Nov and time is 9AM. Then in our Application one date should be default selected

and this date should 22 Nov. After one hour when 10 AM starts default selected date should be 23 Nov.






Thanks in Advance

Rishi

2 Replies
nareshthavidishetty
Creator III
Creator III

Hi Rishi check this.

=date(today()-1,'M/D/YYYY')

Mark_Little
Luminary
Luminary

I would look at adding an action OnOpen. Setting > Document properities > Trigger

The select in field. Date feild and then something like below

= IF(SubField(Now(),' ',2) < '10:00:00',

  Today()-2,

  Today()-1)

Mark