KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

How to select and pass the month and year values #2043

Open Abhishek opened this topic on on Apr 22, 2021 - 2 comments

Abhishek commented on Apr 22, 2021

Dear Team, I am using date time picker in my report,but i need to select and pass the month and year value to SQL query but i am unable to pass the values to backed code and i am providing the view code of the date time below. so could you please help me on how to pass the values.

<div class="col-md-4 form-group" style="margin:auto 32%">
                <strong>Select Date</strong><br>
                  <div class="row">
                    <div class="col-md-6">
                        Month:
                        <?php
                        DateTimePicker::create(array(
                            "name"=>"startDatePicker",
                             "format"=>"MM",
                        ));
                        ?>
                    </div>
                    <div class="col-md-6">
                        Year:
                        <?php
                        DateTimePicker::create(array(
                            "name"=>"endDatePicker",
                             "format"=>"YYYY"
                            ));
                        ?>
                     </div>
					        
                </div>
Abhishek commented on Apr 22, 2021

Dear Team, I am using date time picker in my report, but i need to select and pass the month and year value to SQL query but i am unable to pass the values to backed code and i am providing the view code of the date time below. so could you please help me on how to pass the values.

Abhishek commented on Apr 23, 2021

Dear Team, I am using date time picker in my report, but i need to select and pass the month and year value to SQL query but i am unable to pass the values to backed code and i am providing the view code of the date time below. so could you please help me on how to pass the values.

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
help needed

Inputs