Displaying 3 results from an estimated 3 matches for "ddate1".
Did you mean:
date1
2012 Aug 05
4
find date between two other dates
Hi,
I am trying to assign "Season" values to dates depending on when they occur.
For example, the following dates would be assigned the following "Season"
numbers based on the "season" intervals detailed below in the code:
ddate Season
29/12/1998 20:00:33 1
02/01/1999 05:20:44 2
02/01/1999 06:18:36 2
02/02/1999
2024 Jun 09
2
Format
...19/08/21
2 30/04/18
3 28/08/21
4 11/10/21
5 07/09/21
6 15/08/21
7 03/09/21
8 23/07/18
9 17/08/20
10 23/09/20
[1] 1270076 1
I am using the following different scenarios but none of them resulted
the desired result.
library(data.table)
library(stringr)
library(lubridate)
Atest$ddate1 <- as.Date((Atest$ddate), format = "%m/%d/%y")
Atest$ddate2 <- mdy((Atest$ddate))
Atest$ddate3 <= as.Date(as.character(Atest$ddate),format="%m/%d/%y")
Atest$ddate4 <- as.Date(as.character(Atest$ddate),"%m/%d/%y")
Atest$ddate5...
2024 Jun 09
1
Format
On 2024-06-09 4:39 p.m., Val wrote:
> HI all,
>
> My
> I am trying to convert character date (mm/dd/yy) to YYYY-mm-dd date
> format in one of the columns of my data file.
>
> The first few lines of the data file looks like as follow
>
> head(Atest,10);dim(Atest)
> ddate
> 1 19/08/21
> 2 30/04/18
Those aren't legal months in the first entry.