how to take input date from user in qdateedit and show database accordingly

[vikchh00@gmail.com]

how to take input any date from user in qdateedit or calenderwidget and show database accordingly by clicking button now my code is showing databse of only current

void MainWindow::on_pushButton_2_clicked()
{
    QCalendarWidget *calendar=new QCalendarWidget;
    QDateEdit *dateedit=new QDateEdit;
 
 
    QDate d=calendar->selectedDate();
    ui->dateEdit->setDate(d);
 
 
    int  q= d.year();
    QString q1=QString::number(q);
    int q2=d.month();
    QString q3=QString::number(q2);
    int q4=d.day();
    QString q5=QString::number(q4);
 
    QSqlQueryModel *mode =new QSqlQueryModel(ui->print);
    mode->setQuery(QString("select * from health10  where month(Datestamp)=\""+q3+"\" and day(Datestamp)=\""+q5+"\" and year(datestamp)=\""+q1+"\" ;"));
    ui->print->horizontalHeader()->setSectionResizeMode(QHeaderView::ResizeToContents);
    ui->print->verticalHeader()->setSectionResizeMode(QHeaderView::ResizeToContents);
    ui->print-> setModel (mode);date(todays date) i want user to selct date and show data of that particular date

void MainWindow::on_pushButton_2_clicked()
{
    QCalendarWidget *calendar=new QCalendarWidget;
    QDateEdit *dateedit=new QDateEdit;


    QDate d=calendar->selectedDate();
    ui->dateEdit->setDate(d);


    int  q= d.year();
    QString q1=QString::number(q);
    int q2=d.month();
    QString q3=QString::number(q2);
    int q4=d.day();
    QString q5=QString::number(q4);

    QSqlQueryModel *mode =new QSqlQueryModel(ui->print);
    mode->setQuery(QString("select * from health10  where month(Datestamp)=\""+q3+"\" and day(Datestamp)=\""+q5+"\" and year(datestamp)=\""+q1+"\" ;"));
    ui->print->horizontalHeader()->setSectionResizeMode(QHeaderView::ResizeToContents);
    ui->print->verticalHeader()->setSectionResizeMode(QHeaderView::ResizeToContents);
    ui->print-> setModel (mode);date(todays date) i want user to selct date and show data of that particular date

To copy to clipboard, switch view to plain text mode