I want to show different time as per selection

[Srinivas]

Hi All,

The Date should default to yesterday's date as of 10 AM current day Eastern Standard Time.  Before 10 AM the Date should be the day before yesterday,

This is urgent requirement please help me ASAP.

Advance Thanks

Munna

[HirisH_V7]

Hi ,

Hope this is what you required,

Expression in Text Box:

='Date According to 10 AM every Day  ' & if(TIme(Now('hh:mm:ss TT')) >='10:00:00 AM',Date(Max(Date-1),'DD-MM-YYYY'))

PFA

Hope this Helps,

Regards,

HirisH

[Srinivas]

Hi Hirish,

Date depends on today date , So according to that by default to yesterday's date as of 10 AM current day Eastern Standard Time.  Before 10 AM the Date should be the day before yesterday,

Example:

like date is 24-11-2015 10:00 AM it will show yesterday date 23-11-2015 16:00 PM

or

like date is 24-11-2015 09:00 AM it will show yesterday date 22-11-2015 13:00 PM

Advance Thanks,

Munna

[kumarkp412]

Hi Srinivas,

can you please tell me, how you want to show the time stamp of the date.(10 Am to 16 pm)

Thanks

Kumar

[Srinivas]

Hi Praveen,

I need below way..it's depends on time 10:00 AM

like date is 24-11-2015 10:00 AM it will show yesterday date 23-11-2015

or

like date is 24-11-2015 09:00 AM it will show yesterday date 22-11-2015

Advance Thanks,

Srinivas

[HirisH_V7]

Hi,

Please tell what is the time difference you required and without time difference  it can be like this.

Expression in text box :

='Date According to 10 AM every Day   ' & If(Time(Now('hh:mm:ss TT')) >='10:00:00 AM',Timestamp(Now()-1,'DD-MM-YY h:mm:ss[.fff] TT'))

Please elaborate your Requirement.

Hope this Helps,

Regards,

HirisH