Question 16546 in Laravel Question posted in
The official Laravel Documentation can be found here.

check the date format that is it correct or not – Laravel

i want to check the date format of the database value. I want to put a check in my code if the format of the date string is correct. If it is not correct then store the empty value.

$getTmpAfSite =   DB::table('tmp_af_site')->orderBy('id','DESC')->get(['id','name','email','number','origin','destination','estimated_rate','make','model','year','running_condition','carrier_type','avail_date','lead_source','request_params','bats_id','submitted_on']);
                    
                    foreach ($getTmpAfSite as $key => $value) {
                       
                        $avail_date = ($value->avail_date != '' && $value->avail_date == Carbon::parse($value->submitted_on)->format('m/d/Y')) ? Carbon::createFromFormat('m/d/Y', $value->avail_date)->format('Y-m-d') : '0000-00-00';
                        $submitted_on = ($value->submitted_on != '' && $value->submitted_on == Carbon::parse($value->submitted_on)->format('m/d/Y H:i')) ? Carbon::createFromFormat('m/d/Y H:i', $value->submitted_on)->format('Y-m-d H:i') : '0000-00-00 00:00:00';
                        DB::table('tmp_af_site')->where('id', $value->id)->update([
                            'avail_date'=>$avail_date,
                            'submitted_on'=>$submitted_on
                        ]);
                    }

i am trying this code to check the value but its not working for me. If i didn’t put a check on it and the wrong format comes then the error happens. Here is the error
Unexpected data found. Data missing

Tags:

2

Answers


  1. 0

    try use this function, this function check valid or not valid string date with return true false

    function validateDate($date, $format = 'd-M-Y')
{
  $d = DateTime::createFromFormat($format, $date);
  return $d && $d->format($format) === $date;
}

    if you want more format date, you can add checking date like this

    function validateDate($date)
{
  $valid = 0;
  $format1 = 'Y-m-d';
  $d = DateTime::createFromFormat($format1, $date);
  if($d && $d->format($format) === $date){
    $valid = 1;
  }
  $format2 = 'd-m-Y';
  $d = DateTime::createFromFormat($format2, $date);
  if($d && $d->format($format2) === $date){
    $valid = 1;
  }
  return $valid;
}
    Login or Signup to reply.
  2. 0

    You can use :

    checkdate(int $month, int $day, int $year): bool

    Example :

    <?php
var_dump(checkdate(12, 31, 2000));
var_dump(checkdate(2, 29, 2001));

#bool(true)
#bool(false)

$valid = checkdate(12,31,2000);

if ($valid)
    echo "Date is valid.";
else
    echo "Date is not valid.";

?>

    Regards,

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search