How to deal with special calendar where week is starting from Tuesday 9:00 AM?

[shivani_singhal]

Hi,

I have an issue in making calendar where my week is starting from Tuesday 09:00:00 and ending with Tuesday 08:59:59. 1 day have two dates. And when I select one date suppose 5th July, the I must find the records between 5th July 09:00:00 to 6th July 08:59:59.

Also I have two shifts (one is morning i.e. 09:00:00 to 20:59:59 and other is evening i.e. 21:00:00 to next day 08:59:59). 

Please help me out to deal with this issue.

[mdmukramali · Accepted solution]

Hi ,

For week start from Tuesday

SET FirstWeekDay=1;

For the Timing, I will send you a sample file shortly.

[mdmukramali · Accepted solution]

Hi,

for the day start from 9:00:00 use the below code:

Date(Floor(Timestamp((TimeStamp) - 9/24))) as NewDate,

kindly find the attached sample application also.

Thanks,

Mohammed Mukram

[shivani_singhal]

Thanks for the query.:)

[shivani_singhal]

Hi,

Can you attach the .qvw file also.

[mdmukramali]

I have already attached the QvW.

[shivani_singhal]

No application is attached with your reply.

Please attach the file once again.

Thanks,

Shivani

[shivani_singhal]

I got the application.

Thanks.