Creating Customized Calendar

lakshmanvepuri — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Please let me know how to create the custom calendar based on :

Today ( starting from 7 AM to tomorrow 6:59 AM)

Yesterday ( yesterday 7 AM to today 6:59 AM )

Last 24 hours ( based on the current hour it should get the last 24 hours time stamp )

Thanks a lot.

Note

I have created custom calendar for Current Month, Last Month and Last 30 days.

Let vCurrMonth = Ceil(Today()-MonthStart(Today()));

Let vLastMonth = Ceil(MonthEnd(Today(), -1)-MonthStart(Today(), -1));

Let vCurr_Last = $(vLastMonth)+$(vCurrMonth);

Let v_lastMonthEnd = $(vCurrMonth)+1;

if (vCurrMonth)>0 then

Selection_1:

LOAD * INLINE [

Selection_Name,Selection_Start_Value, Selection_End_Value

"Last 30 Days",30,-1,

"Current Month", $(vCurrMonth),-1

"Last Month",$(vCurr_Last), $(v_lastMonthEnd)

];

else

Selection_1:

LOAD * INLINE [

Selection_Name,Selection_Start_Value, Selection_End_Value

"Last 30 Days",30,-1,

"Last Month",$(vCurr_Last), $(v_lastMonthEnd)

];

end if

regards

Kumar

Message was edited by: Lakshmana Vepuri

Re: Creating Customized Calendar

amit_saini — Tue, 31 May 2016 03:57:10 GMT

Hi,

Not sure if this helps u , but i have done something similar with the help of variables .

Create 2 variable as below:

vStart:=DATE(num(today())-1 + num('06:00:00'),'DD.MM.YYYY hh:mm:ss')

vEnd :=DATE(num(today()) + num('05:59:59'),'DD.MM.YYYY hh:mm:ss')

And then later ,changes at expression side like below:

You need to include these 2 variables to those expression ,which should changes based on ur requirement (Yesterday 6 AM to today's 05:59:59)

Give a try

Thanks,