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: 
Srinivas
Creator
Creator

I want to show different time as per selection

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

5 Replies
HirisH_V7
Master
Master

Hi ,

Hope this is what you required,Data and TIme of Yesterday.PNG

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

HirisH
“Aspire to Inspire before we Expire!”
Srinivas
Creator
Creator
Author

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
Creator II
Creator II

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
Creator
Creator
Author

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
Master
Master

Hi,

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

Data and TIme of Yesterday.PNG

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

HirisH
“Aspire to Inspire before we Expire!”