How to calculate Comparison of times

[rishikeshtiwari]

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

[nareshthavidishetty]

Hi Rishi check this.

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

[Mark_Little]

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