Category "date"

How to sort array of objects by dates and make new arrays which will contain all objects with same date [closed]

I have a very specific problem in Javascript. I have array of objects, and each object contains some date. const array = [ {name: 'first', dat

How do you define the first day of the month (without including week-ends) in a batch script?

I have created a scheduled task in Windows that consists of running a batch script. The problem is that this task has to be scheduled every 1st day of the month

Date comparison Logic / in Liquid Filter

I'm trying to add 30 days to a pre-order date and if today's date is later, display a text string and if not display another text string. Any ideas where I'm go

Convert date to ISO week date in Spark

Having dates in one column, how to create a column containing ISO week date? ISO week date is composed of year, week number and weekday. year is not the same as

bug when adding a month with date-fns add() method?

I've been trying to add just one month to a date using date-fns add() function. It works as advertised most of the time. period = new Date('2021-03-01') //im a

Convert string to date using arrow python

I'm trying to convert string to date using arrow module. During the conversion, I received this error: arrow.parser.ParserMatchError: Failed to match '%A %d %B

How to validate the date in a varchar column in SQL Server

I have a staging table which contains all varchar columns. I want to validate a date stored in the data column. Since my staging table contains all varchar colu

firestore query filter by date in firebase console

I am wondering how to filter firebase firestore by date field, as I can't see data type other than String, Number, Boolean As below, please advice if someone fi

firestore query filter by date in firebase console

I am wondering how to filter firebase firestore by date field, as I can't see data type other than String, Number, Boolean As below, please advice if someone fi

Order By Date desc evaluates 01-01-1970 higher then everything else

I have the following simplified query SELECT id to_char(execution_date, 'YYYY-MM-DD') as execution_date FROM schema.values ORDER BY execution_date DESC,

Check if page creation date is within the last 7 days with Eleventy and Nunjucks?

I posted a few days ago about having a way to check for newly created posts, and I am making some headway in this but got a little stuck as shortcodes are still

How to select date only from database that storing dob as datatype timestamp without timezone in java

I have a table in PostgreSQL that stores dob as datatype timestamp without timezone example value '1997-12-03 07:00:00'. My entity class is as follows @Tab

Chrome: HTML date input produces strange comma

Whenever I use "input with type="date"" in Chrome, there is a strange comma on the left of the date input. There is no such comma in Firefox and I cannot find a

Join tables on dates, with dirty date field

In AWS Athena, I am trying to join two tables in the db using the date, but one of the tables (table2) is not clean, and contains values that are not dates, as

Excel problem: Exported from OBIEE to Excel analysis adding time part to a date column

There is a date column used in OBIEE analysis. That column is declared as 'date' datatype in Oracle table, type in rpd is also 'DATE'. However, when exported to

JS how to add hours and minutes to scheduled date

I need to be able to let clients schedule a certain type of meeting for a future date, the meeting duration I get back from the database is in minutes. I need t

How to calculate from a date to another date?

I am creating a workday calendar which calculates which date the workday ends. I have a code that sets daily worktime from e.g 8:00-16:00 (workDayStartStop). An

Flatpickr set minDate and maxDate dynamically by other field value in field setting without custom JS

How could I set the minDate of a "end date" field to by dynamically bigger than the "start date" field by references to the start date input id without custom J

How to convert a given ordinal number (from Excel) to a date

I have a Value 38142 I need to convert it into date format using python. if use this number in excel and do a right click and format cell at that time the value

Power BI: Order data by YearMonth in DAX

I would like to create a YearMonth column in Power BI and group data in this order in visual plot, say histogram. I tried to create a duplicate of the datetime