Category "date"

How to add random minutes like first slots should be 30 minutes and then 1 of 15 minute slot and again 30 minute slot

const eventClick = (args) => { let StartTime = moment(args?.event?.StartTime, 'HH:mm ') let EndTime = moment(args?.event?.EndTime, 'HH:mm ') if (

convert month of dates into sequence

i want to combine months from years into sequence, for example, i have dataframe like this: stuff_id date 1 2015-02-03 2 2015-03-03 3

PHP | Parse specific german date format to yyyy-mm-dd

Hey I am struggling with a date format . I need to adjust the display of some dates in a wordpress project. Its not a duplicate of This question I tried the sug

PHP: Parse date from localized format

I need to parse a date string in a multi-language application. Every user has their locale and then their date format. How to use: new DateTime($datestr); o

Create a new Date for any specific timezone

I am using Google Apps Script to check and re-format date data from some Google Sheets. But the problem is the result shows the times for the user who run the c

view limit minimum 0.0 is less than 1 with matplotlib

I know there are similar questions to mine below, but mine is minimal and does not have anything to do with pandas and also solution pd.to_datetime did not work

How to formate or validate date in java like 20992012 or 12122022? [duplicate]

i have to validate date yyyyMMdd or MMddyyyy or ddMMyyyy. if i pass input 20221224, ho to make this is valid? but how can i do this in regex

Computing number of business days between start/end columns

I have two Dataframes facts: columns: data, start_date and end_date holidays: column: holiday_date What I want is a way to produce another Dataframe that has

If date is older than 6 months and value is X, then output this

I have two columns in excel, one with a date and one with a rating 'low, medium, high'. I'm trying to write a formula to put in a third column that checks: If A

Add missing dates to pandas dataframe

My data can have multiple events on a given date or NO events on a date. I take these events, get a count by date and plot them. However, when I plot them, my

Subtract the date from each cell in a column, skip cells that have string values

I have an Excel sheet of expiration dates. Some rows lack an expiration date so I chose to fill those cells with the string “NO DATA”. I want to loo

Google Sheets conditional formatting with differently styled dates

in Google Sheets I'd like to format an area of cells automatically by comparing its date value to another cell. In fact, I have some cells representing a month

How do obtain max and mean values from different columns with a Date column condition in R?

I am trying to get the daily mean and maximum values for each pollutant. For each of the monitoring stations, the daily mean and maximum values of each pollutan

Convert given UTC timestamp string to unix timestamp

I'm struggling with this small snippet: import time from datetime import datetime start = "2022-05-14T10:00:00" start_date = datetime.fromisoformat(start) star

How to parse date from year and quarter using java.time

I am trying to parse strings in the format of "<year> <quarter>" ("2022 1", "2022 2") into java.time.LocalDate objects. The closest related question

Extracting year from a column that contains dates in m/d/yyyy format

I have a dataset called verts imported from Excel with a column called Date that contains dates in this format: m/d/yyyy. I'm trying to extract the year from th

Subtracting 10 hours should move to yesterday, but it doesn't

I'm subtracting 10 hours from date object. Expecting to get yesterday's date. But I get the same date. Is it a bug in ads-script? var now = new Date(); Log

Delete Rows a day after the date has passed

I am still fairly new at script writing and am trying a write a script that deletes a row one day after the date which is in column L. The data is in range A133

How to get week numbers from dates?

Looking for a function in R to convert dates into week numbers (of year) I went for week from package data.table. However, I observed some strange behaviour: &

Checking if the entered date is the start of a quarter

Good afternoon! Can you please tell me how to implement a function that checks if the passed date is the beginning of the quarter? I tried to implement validati