Questions tagged [date-manipulation]
The date-manipulation tag has no usage guidance.
date-manipulation
91
questions
0
votes
0
answers
21
views
WORKDAY Google Sheet formula in SQL Google Console
I need to find a new date adding to the current one a number, but excluding weekends.
I can do this in Google Sheet with the WORKDAY formula but I need to do it in SQL.
As an example:
Current day: ...
-1
votes
1
answer
81
views
Why am I not getting an exact time when adding days to a time? [duplicate]
In .NET Core 6 I am getting a funny result when adding days, and it only happens in one project but not in another.
var time = 3.2986111640930176;
var firstDate = new DateTime(2023, 7, 1);
var newDate ...
0
votes
1
answer
36
views
Merging Data with Power Query and 2 Columns and Dates
I really need some help on merging data in Power Query. I am importing data from a file (from a network drive) and also pulling data from a static table. However I am trying to obtain a match with ...
3
votes
2
answers
771
views
Using Duration to check if hours between two days are still within Duration
I was working with LocalDateTime and trying to see if the purchase date(in my case) is withing last x units(days/hours)
I achieved this the following way
public static final int ...
-4
votes
2
answers
95
views
Create first Instant of year 2022 [closed]
I have an int representing the year 2022, and I want to create an Instant object representing the first instant of the year, meaning: 2022-01-01 00:00:00.
int year = 2022;
Instant instant = ...
How ...
0
votes
0
answers
131
views
How to convet a datepicker value to a string with Selenium Java
Am using Selenium webdriver with Java so I need to print my date from date picker but its failing:
I want to convert this datepicker value to a string:
//WebElement fullDate = driver.findElement(By.id(...
-1
votes
1
answer
340
views
In Google Sheets I am trying to compute room occupancy per month from a list of dates
I have found numerous ways of getting parts of the result, but I'm obviously lacking in-depth knowledge of the various functions to arrive at what I need.
Sample data:
arrival | departure
11/25/...
1
vote
0
answers
32
views
addin days in provided date by user
String pickupdate = pdate.getText().toString().trim();
// String dateBefore = "25/10/2022";
// create instance of the SimpleDateFormat that matches the given date
...
0
votes
1
answer
1k
views
Substract one day of date in Jasper [duplicate]
i have this code in my JasperReport like that new SimpleDateFormat("dd/MM/yyyy").format(new Date()) - 24 * 3600 * 1000 but it's not working, what i'm trying is substract one day from today. ...
0
votes
1
answer
1k
views
How to get a specific date of next month? (Java 8)
With today's date, I should get the 16th date of next month.
For example, on passing 13-12-2021, I should get 16-01-2022.
I need to get the next month 16th day from current date (input date). Examples:...
1
vote
3
answers
671
views
How to get the next n fridays which are the first, second or third friday in a month?
I need to find the next n Fridays but want to exclude 4th and possibly 5th Fridays, i.e I want to get the next n Fridays which are 1st, 2nd or 3rd of each month. I have found a way to stream over the ...
0
votes
2
answers
105
views
Creating a temp table for the off hours of the organization
I need to create a temp table that will have a Start_Date and an End_Date column based on input parameters sdate and edate. This table is the list of the off-hours of the office which includes 6pm to ...
0
votes
2
answers
165
views
logic error in the code used for get the last day of a month
i need to write a code that takes in input an integer called mese(this int goes from 0 to 5), this integer will be added to the current month, that becouse call this function when i need to get the ...
0
votes
1
answer
585
views
Output most recent date Excel
I'm looking to derive a formula which will output the most recent date between cells CK:CM. My sheet looks like this:
For row 2, output should be 2021-06-04, row 4 should be 2021-05-06, row 5 should ...
-1
votes
1
answer
1k
views
How to parse the date for February and months with 31 days?
I thank you for possible answers. The problem is, I work with a legacy system with Java 1.4. In a registration form you have the following fields: 'Period' in the mm / yyyy format 'Expiration Day' ...