InMonthToDate

[#1]

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

[#2]

Hi Skip ,

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

Regards,

~Ivan

[#3]

Hi,

Use  inyeartodate function.

Please find the attached file.

Thanks,

Nirnajan M.