Skip to content

Tag: date

Subtracting days from a future date

It is working as expected. $newdate prints as 1 December 2022 However, if the $tour_date is not the current year, it does not work properly. It is still printing as 1 December 2022. The $newdate prints as 1 December 2022. But it should be 1 December 2023 which is -10 days from 11 December 2023. Any idea, that…

Datatype date is not updating in mysql using laravel

A column named ‘Shipment’ in import_request_trackers table having the datatype of Date and initially the default value is null. But when I tried to update the column from another form manually it shows no error but the database table is not being updated. } Answer 1- check your route first, please…

How to process insane date inputs with php

I have a code in php for processing the personal details of a person. I need code to handle the date input such that when the user inputs a year like 1900 and below then the program outputs That is impossible. I have successfully handled how the program should respond if the date input is in the future. The p…

Show a date depending on day and time

I have this script that echo’s the upcoming Thursday, unless it’s Wednesday because then it shows the Thursday a week later. This works great. But what I would like is to add a cut-off time on Wednesday on 5PM (17:00 GMT+1 / CEST). So before 5PM it will still show the next Thursday (day after) but…

DQL with between – string date – PHP

I am trying to do a sql with between. The date data is entered first as a string. Any help with this question? Answer The string is dd/mm/yyyy At the final you will get date like 2021-09-28 and now we can do a between with actual date 2021-10-01 after this you can see the sentence in DB with dd($query->get…

Get week range with timezone

I’m trying to get week range for a given date. I use the below code to do so. How can I make it work so it take timezone into account? My timezone is GMT+1 but the returned date has – 1 hour difference Answer You can use date_default_timezone_set() for that. https://www.php.net/manual/en/function.…

Increment variable date in PHP

I am grabbing the post published date (WordPress) and trying to add 2 days to it to create a post expiry date. But I am throwing the following error: Notice: A non well formed numeric value encountered Here is my code: Can anyone point out my error here please? Answer When using slashes to separate your date …

Separate date to several intervals

I’ve got an array like the following : And another array : I would like to create a new $array3 that removes the intervals from $array2 in $array1 to give the following result : As you can see, in $array3 2 new entries were added to remove the interval used in $array2. I don’t know how can I tackl…