How to set current year and previous year in variables using php?

Question

there is one scenario. assume that:
financial year = 01/04/2017 to 31/03/2018
I have one input field with datepicker and date column in database. If any user will select today's date e.g 08/06/2017
then there should display data for this current year i.e from 01/04/2017 to 08/06/2017 with the help of date table
and at the same it should display previous year's data i.e from 01/04/2016 to 31/03/2017
For the time I am using $currentdate = date('d/m/Y') to display whole data from db till current date.

$A1 = mysqli_query($conn,'SELECT sum(netvalue) FROMfintranWHERE groupNo = 21 AND docDate <= "'.$currentdate.'" ');

We can create some formula but i am so poor to build logic so please help me

Possible duplicate of Date minus 1 year?

Robson
– Robson

2017-06-07 19:02:36 +00:00
Commented Jun 7, 2017 at 19:02 — Robson
– Robson, Commented Jun 7, 2017 at 19:02

Ajay Kumar · Accepted Answer · 2017-06-07 20:41:18Z

1

You use Carbon.
Documentation :- http://carbon.nesbot.com/docs/

$date = Carbon\Carbon::createFromFormat('d/m/Y', $date);
$date->subYear(); 
echo $date->format('d/m/Y'); // Previous year

answered Jun 7, 2017 at 20:41

Ajay Kumar

1,34212 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Robson · Accepted Answer · 2017-06-07 19:21:01Z

1

You can use the following method for generating date one year back:

function get_year_back_date($date, $format='d/m/Y') {
    return date($format, strtotime($date . ' -1 year'));
}

$previous_year = get_year_back_date('01/04/2017');

Here you can see this code in action: http://ideone.com/eXRoYB.

edited Jun 7, 2017 at 19:21

answered Jun 7, 2017 at 19:06

Robson

8135 gold badges23 silver badges44 bronze badges

3 Comments

Andreas Over a year ago

May I suggest: date('d/m/Y', strtotime('01/04/'. Date("Y") .' -1 year')) to make it more future safe?

Andreas Over a year ago

Or whatever date year the user selects

Robson Over a year ago

@Andreas I've updated my answer to the fairly general function.

Collectives™ on Stack Overflow

How to set current year and previous year in variables using php?

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related