I have selected a month from month field <input class="form-control" type="month" id="report_month" name="report_month" value="{{ old('report_month') }}"> That value is '2023-02'. How to get last date of that specific month in controller? Value required is :2023-02-28
I am using PHP and Carbon and would like to check if two dates fall between another two dates. As an example, say I have: $eventStart = '2023-04-01'; $eventEnd = '2023-09-14'; $rangeStart = '2023-07-01'; $rangeEnd = '2023-07-31'; The 'event' which…
I am trying to determine the difference in months between the date the user is created and the current date. However, if any of the date involves february it will result in the difference being returned to potentially be wrong.…
Hello Every I want to use Laravel default casts feature, where if I access created_at property of a post model. I would like the following output from the following code: Code: $timepassed = $post->created_at; Desired Output: 2 hours ago The…
How do I pass successive dates if I use a loop to pass dates that are in the array? I created a simple function to solve my problem but I got stuck when I get > 1 date successive. Code…
Users can set their timezone and we store it in the database. Then we can dynamically change the system timezone on each page load in Middleware or in our AppServiceProvider. Example: https://stackoverflow.com/a/47938555/5156146 The problem with this is that it messes…
How to create DateTime object with PHP from this string: 2022-06-21T05:52:46.648533678Z? There is nine numbers after 'dot', after seconds. I tried to use next variants: <?php Carbon::createFromFormat('Y-m-dTH:i:s.uP', '2022-06-21T05:52:46.648533678Z'); Carbon::createFromFormat('Y-m-dTH:i:s.vP', '2022-06-21T05:52:46.648533678Z'); And always get an error: The timezone could not be…
I am using Laravel and have this code: $date = now()->locale('es_ES'); $start_date = $date->isoFormat('D [de] MMMM [de] YYYY') $start_time = $date->isoFormat('HH[H]hh') $end_date = $date->addHours(3)->isoFormat('D [de] MMMM [de] YYYY') $end_time = $date->addHours(3)->isoFormat('HH[H]hh') this is the output start_date : 24 de abril…
To calculate working hours, I need to separately calculate the number of hours that the user worked during working hours(09:00 - 17:00) and outside of working hours (overtime) and return their sum. For example, the user worked from 2023-01-23 15:00…
Background My app uses UTC as the timezone for the database, as it should. Right now all my users are local, but I will have users in many different time zones. Most things in my app are just dates, so…