InMonthToDate

Mon, 09 Apr 2012 02:50:36 GMT

Hi Guys,

We are using Fiscal Calendar in the company.

Example for the month of March the start day is 26 Feb to 31 Mar.

Is there a way that I can use InMonthToDate when I am not referring March 1 as the start date?

Sample Data: (Today's date is 05 March)

QTY AMT DATE (This is what I need)

10 100 25/Feb/2012 = False

20 200 27/Feb/2012 = True

30 300 4/Mar/2012 = True

If I used InMonthToDate directly the result is (which is not what I need)

QTY AMT DATE

10 100 25/Feb/2012 = False

20 200 27/Feb/2012 = False

30 300 4/Mar/2012 = True

Thanks for your help.

Regards,

~Skip

Mon, 09 Apr 2012 05:15:51 GMT

Hi Skip ,

You can use 'IntervalMatch ( Date ) select MonthStart, MonthEnd from YourDBorExcelFile'.

Regards,

~Ivan

Re: InMonthToDate

Mon, 09 Apr 2012 06:09:13 GMT

Hi,

Use inyeartodate function.

Please find the attached file.

Thanks,

Nirnajan M.