private void loadDay() throws SQLException, Exception {
        dDL = new DayDL(c);

        DecimalFormat decFormat = new DecimalFormat("#.##");
        SimpleDateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");

        java.util.Date date = new java.util.Date();
        java.sql.Date sqlDate = StrUtil.dateParser(dateFormat.format(date));

        //fetching day details
        d = dDL.fetchDayByDate(sqlDate);

        //first clearing fields
        clear();

        //setting values on fields and check boxes
        dateL.setText(dateL.getText() + dateFormat.format(date));
        statusL.setText(date.toString());

        if (d != null) {
            existing = true;
            id = d.getDayID();

            summaryArea.setText(d.getSummary());

            expensesF.setText(decFormat.format(d.getExpenses()));

            if (d.getSex() == 1) {
                sexChk.setSelected(true);
            }

            if (d.getWork() == 1) {
                workChk.setSelected(true);
            }

            if (d.getFun() == 1) {
                funChk.setSelected(true);
            }

            if (d.getSpecial() == 1) {
                specialChk.setSelected(true);
            }

            if (d.getAlcohol() == 1) {
                alcoholChk.setSelected(true);
            }

            loadContactL();
        } else {
            existing = false;
        }
    }