Hi! I an having a hard time translating this script into R.
I basically need to have a start and end date from the posting date column, give that range of time a new name and from that translate that time range into a new column.
- DEFINE FIELD c_Month_to_Summarize_On COMPUTED
SUBSTRING("December 22,2018 - January 21,2019",1,50) IF Posting_Date >= 20171222
AND Posting_Date <= 20190121
SUBSTRING("January 22,2019 - February 21,2019",1,50) IF Posting_Date >= 20190122
AND Posting_Date <= 20190221
SUBSTRING("February 22,2019 - March 21,2019",1,50) IF Posting_Date >= 20190222
AND Posting_Date <= 20190321
SUBSTRING("March 22,2019 - April 21,2019",1,50) IF Posting_Date >= 20190322
AND Posting_Date <= 20190421
SUBSTRING("April 22,2019 - May 21,2019",1,50) IF Posting_Date >= 20190422
AND Posting_Date <= 20190521
SUBSTRING("May 22,2019 - June 21,2019",1,50) IF Posting_Date >= 20190522
AND Posting_Date <= 20190621
SUBSTRING("June 22,2019 - July 21,2019",1,50) IF Posting_Date >= 20190622
AND Posting_Date <= 20190721
SUBSTRING("July 22,2019 - August 21,2019",1,50) IF Posting_Date >= 20190722
AND Posting_Date <= 20190821
SUBSTRING("August 22,2019 - September 21,2019",1,50) IF Posting_Date >= 20190822
AND Posting_Date <= 20190921
SUBSTRING("September 22,2019 - October 21,2019",1,50) IF Posting_Date >= 20190922
AND Posting_Date <= 20191021
"OTHER"*
However my code when i write it out which is as below, gives me a crazy error.
t_Purchase_Card_Monthly_Summary <- pc%>%
mutate(c_Month_to_Summarize_On =("January 22,2019 - February 21,2019" = (Posting_Date >= "20190122") ,(Posting_Date<= "20190221"),
"February 22,2019 - March 21,2019" = (Posting_Date >= "20190222"), (Posting_Date<= "20190121"),
"March 22,2019 - April 21,2019" = (Posting_Date >= "20190322"), (Posting_Date<= "20190121"),
"April 22,2019 - May 21,2019" = (Posting_Date >= "20190422") , (Posting_Date<= "20190121"),
"May 22,2019 - June 21,2019" = (Posting_Date >= "20190522") , (Posting_Date<= "20190121"),
"June 22,2019 - July 21,2019" = (Posting_Date >= "20190622") , (Posting_Date<= "20190121"),
"July 22,2019 - August 21,2019" = (Posting_Date >= "20190722") ,( Posting_Date<= "20190121"),
"August 22,2019 - September 21,2019" = (Posting_Date >= "20190822") ,(Posting_Date<= "20190121"),
"September 22,2019 - October 21,2019" = (Posting_Date >= "20190922") ,( Posting_Date<= "20190121"))%>%