Daterange picker range for financial year

Question

0.00/5 (No votes)

See more:

, +

I have problem with showing current financial year and last financial year in bootstrap date range picker. i need this financial year to be from April 2016 to March 2017. But presently this financial year showing April 2017- March 2018. But January 2017 coming under Last financial year on selection.

JavaScript

//Date range as a button
   $('.daterange-btn').daterangepicker({
       ranges: {
           'Today': [moment(), moment()],
           'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
           'Last 7 Days': [moment().subtract(6, 'days'), moment()],
           'Last 30 Days': [moment().subtract(29, 'days'), moment()],
           'This Month': [moment().startOf('month'), moment().endOf('month')],
           'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')],
           'This Financial Year': [moment().month(new Date(startDate).getMonth()).startOf('month'), moment().month(new Date(startDate).getMonth()).startOf('month').subtract(1, 'days').add(1, 'year')],
           'Last Financial Year': [moment().month(3).startOf('month').subtract(1, 'year'), moment().month(3).startOf('month').subtract(1, 'days')]

       },
       startDate: moment().subtract(29, 'days'),
       endDate: moment()
   }, function (start, end) {
       Search(start.format('DD-MMM-YYYY'), end.format('DD-MMM-YYYY'));
   });

What I have tried:

I am unable to solve this please help

Posted 16-Jan-17 0:52am

Member 10212775

Updated 16-Jan-17 4:50am

OriginalGriff

v2

Add a Solution

2 solutions

Solution 1

why don't you try jquery datepicker.Here,we can provide year and month range

Posted 16-Jan-17 1:57am

priyanka456

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Accepted Answer · 2017-01-16T04:50:00

Hardly surprising, given your range definitions:

JavaScript

'This Financial Year': 
[
    moment() // 2017-01-16
        .month(new Date(startDate).getMonth()) // 2017-04-16
        .startOf('month'), // 2017-04-01
    
    moment() // 2017-01-17
        .month(new Date(startDate).getMonth()) // 2017-04-16
        .startOf('month') // 2017-04-01
        .subtract(1, 'days') // 2017-03-31
        .add(1, 'year') // 2018-03-31
],
'Last Financial Year': 
[
    moment() // 2017-01-16
        .month(3) // 2017-04-16
        .startOf('month') // 2017-04-01
        .subtract(1, 'year'), // 2016-04-01
    
    moment() // 2017-01-16
        .month(3) // 2017-04-16
        .startOf('month') // 2017-04-01
        .subtract(1, 'days') // 2017-03-31
]

You need to check whether the current month is before the start of the financial year. If it is, then both ranges shift back a year.

JavaScript

var currentMonth = new Date().getMonth();
var financialYearStartMonth = new Date(startDate).getMonth();
var financialYearStartDate = moment().month(financialYearStartMonth).startOf('month');
if (currentMonth < financialYearStartMonth) {
    financialYearStartDate = financialYearStartDate.subtract(1, 'year');
}

$('.daterange-btn').daterangepicker({
    ranges: {
        ...
        'This Financial Year': [financialYearStartDate, financialYearStartDate.add(1, 'year').subtract(1, 'days')],
        'Last Financial Year': [financialYearStartDate.subtract(1, 'year'), financialYearStartDate.subtract(1, 'days')]
    },
    ...