Days Count for 0CALMONTH

[Former Member]

Hi SCN,

Is it possible that we can get the number of days for a 0CALMONTH interval variable in WebI?

Planning to use =DaysBetween([Start Date];[End Date])

but is it possible with the 0CALMONTH object.

The user inputs 01.2014 - 02.2014. Variable we are using is 0P_CALMONTH (between from and to). Final output 31 + 28 = 59 days.

Thanks.

[Former Member]

Hi,

its is possible but you have to convert the user input to date and then apply the daysbetween logic.

Thanks,

Swapnil

[Former Member]

Hi Swapnil,

So do we need to do a formula to place a day data for the input OR 0CALMONTH is already enough for us to calculate the days?

Thanks.

[Former Member]

CALMONTH is a string so that will return you only string.. now u have to conver the string to actual date so that you can feed those dates to input for DaysBetween formula in WEBI.