All Questions
1,501
questions
0
votes
0
answers
27
views
Convert string to timestamp in pinescript
I'm importing a string that I then turn into an array. I would like to use the date and time values inside the array to draw lines from. The issue seems to be that a const string is expected. Is there ...
0
votes
0
answers
18
views
Type Mismatch while using FlatFileItemReader BeanWrapperFieldSetMapper from String to Date
I am trying to batch process a file which has date field. Now when I fetch Date field using FlatFileItemReader it comes as a String.
I am trying to map it to following entity
@Entity
@Data
public ...
- 23
0
votes
1
answer
33
views
VBA function FindInRow not always work - Find a cell in an excel row containing either text or date
Sometimes my VBA function FindInRow works, sometimes it doesn’t.
The VBA function FindInRow is used to find if a 'text' exists in an Excel row or not. If the text is found in the row, the function ...
- 161
0
votes
3
answers
44
views
Ignore characters in a string to make an R date
Im trying to get the date from a string such as: "ID0123122021".
Where the first two digits are an id, then the month then the year.
So it would be equivalent to "IDnnnnmmyyyy" and ...
0
votes
1
answer
50
views
Using 4 characters to represent future Epoch time and compare to current day [closed]
I would like to ask for best practices or ways to improve my code for my very specific problem I am solving which involves taking a 4 character limited length string to represent a future date it ...
- 21
2
votes
3
answers
91
views
Find occurrence of YYYYmmDD date in variable string
Suppose I have a string containing dates in YYYYmmDD format but in variable position and containing also other numeric sequences
For example:
xx12x20240113yyyy123zzzz
20240201xxxx34yyy
...
- 21
1
vote
0
answers
53
views
How do I tell pandas not to parse dates from excel(leave the string as is)? I tried every option of dytpe and converters but it still does not work
This is how my excel file looks:
| SNo | Date |
| 1 | 28/2/2024|
| 2 | 29/2/2024|
|3 | 1/3/2024|
etc
So when I read this data into pandas, I want this date string to be
retained as in the pandas ...
0
votes
2
answers
40
views
Combine two rows of date strings in a dataframe
I have a dataframe that looks similar to the one below:
Date A B C
01/01/2020 a1 b1 c1
03/17/2020 a2 b2 c2
03/30/2020 a3 b3 c3
06/24/2020 a4 b4 c4
06/25/2020 a5 b5 c5
11/01/...
- 83
1
vote
1
answer
55
views
Javascript convert from string number to integer [duplicate]
I am creating an excel date format while I using JavaScript but I got stuck about convert string to integer.
function getCurrentDateFormat (date,errorValue, removeSecond, clientTimeZoneOffset) {
...
- 51
-1
votes
2
answers
92
views
How to convert a string with extra characters
How to convert a string with extra characters
String str = "file-09-01-2024"
pattern = "dd-MM-YYYY"
using SimpleDateFormat with pattern = "dd-MM-YYYY"
I don't know how ...
- 25
-2
votes
1
answer
91
views
c# convert date from DateTimePicker into String
I try to convert something like this: "Wednesday, 21. January 2024" into this: "03.01.2024". How can I do this in c#?
I will use it for a program. There is an DateTimePickerand I ...
0
votes
0
answers
40
views
Change the raw string representation of a date in Javascript
I have a series of Javascript classes that extend the Date object to cover different calendars. The idea is that, regardless of calendar, the Unix timestamp stored by a Date object is universal.
So, I ...
0
votes
0
answers
53
views
php find earliest date in the format dd/mm/yyyy in a text file
I have a text file in the following format
03/12/2023 06 This is the text in the line
03/12/2023 06 This is the text in the line
03/12/2023 06 This is the text in the line
03/12/2023 06 This is the ...
1
vote
0
answers
70
views
Problem with excel recognizing dates to create text
Currently, I am truly stumped as to what could be wrong.
The problem:
I have a cell in excel formatted as a date (e.g., 19/10/2023). I would like to take that cell and format it as a text in another ...
- 11
1
vote
1
answer
34
views
How to transform many variables (characters) to the dmy format using `dmy` function?
Let's say I have this df (but so much bigger)
library(lubridate)
df = data.frame(id=1:5,date1 = c("2023/01/02","2023/08/03","2023/09/09","2023/11/05","...
- 903