How do you convert all the dates in a table within a column to a character?
2 次查看(过去 30 天)
显示 更早的评论
BA
2022-7-24
I have a bunch of dates in a column. I want to convert all the dates to chars. For example:
Lets say I have a column with these dates:
1/2/22
1/3/22
1/4/22
1/5/22
%Ideally there would be code here that runs a function to convert these
%dates to chars
Output:
'1/2/22'
'1/3/22'
'1/4/22'
'1/5/22'
I would like to use the split function and the only way to use it is for the dates in my table to be chars.
Have attached the dataset in case it helps. The columns that I want to convert to chars are
General_Prompt_SurveySubmittedDate_1
General_Prompt_SurveySubmittedDate_2
General_Prompt_SurveySubmittedDate_3
And then I want to split the data using '/'
采纳的回答
Siddharth Bhutiya
2022-7-28
First to answer your question on how you could convert the datetime array into char. It is extremely simple, you can call "char" or "string" on the datetime array and it would be converted to text. I would suggest using "string" because char will have its own problems when your timestamps are not all same length. And all text manipulation functions like split would work on strings. See an example of how to do it.
Always use datetime methods (string,char) over legacy functions like datestr which are no longer recommended.
>> dt
dt =
4×1 datetime array
01/02/22
01/03/22
01/04/22
01/05/22
>> s = string(dt)
s =
4×1 string array
"01/02/22"
"01/03/22"
"01/04/22"
"01/05/22"
>> split(s,"/")
ans =
4×3 string array
"01" "02" "22"
"01" "03" "22"
"01" "04" "22"
"01" "05" "22"
1 个评论
BA
2022-7-28
Wow, that's really helpful. Thanks.
I will also keep in mind about the datetime function. I'm currently new to MATLAB and I've been utilizing some legacy code so its good to know.
Thanks again!
更多回答(1 个)
Chunru
2022-7-25
编辑:Chunru
2022-7-25
If you use readtable, your date and time columns are already in cell char format as shown below.
%x = readtable("https://www.mathworks.com/matlabcentral/answers/uploaded_files/1075655/Stacked.xlsx");
%head(x)
load Stacked.mat
General_Prompts_Stacked.General_Prompt_SurveySubmittedDate_1 = datestr(General_Prompts_Stacked.General_Prompt_SurveySubmittedDate_1, ...
'dd-mmm-yyyy');
head(General_Prompts_Stacked)
ans = 8×153 table
General_Prompt_SurveySubmittedDate_1 General_Prompt_SurveySubmittedTime_1 HowMuchDoYouFeel_Sad_Unhappy_DownInTheDumps_Miserable__1 HowMuchDoYouFeel_InAGoodMood_1 HowMuchDoYouFeel_ConnectedWithOthers_1 HowMuchDoYouFeel_Psychological_emotionalPain_EmotionsT_1 HowMuchDoYouFeel_Bored_1 HowMuchDoYouFeel_LikeYouNeedToEscape_ThingsAreSoBadYou_1 HowMuchDoYouFeel_Agitated_irritated_YouAreCrawlingOutO_1 HowMuchDoYouFeel_Worried_YouAreThinkingAboutBadThingsT_1 HowMuchDoYouFeel_Anxious_FeelingLikeBadThingsCouldHapp_1 HowMuchDoYouFeel_Energetic_YouFeelAwakeAndWithEnergyTo_1 HowMuchDoYouFeel_Self_hatred_YouHateHowYouAreAsAPerson_1 HowMuchDoYouFeel_Angry_YouFeelAnnoyed_Resentment_OrExa_1 HowMuchDoYouFeel_OnEdge_On_highAlert_Or_onGuard___1 HowMuchDoYouFeel_Numb_YouHaveDifficultyFeelingEmotions_1 HowMuchDoYouFeel_Grateful_ThankfulOrAppreciativeForThe_1 HowMuchDoYouFeel_PhysicalPainOrDiscomfort_1 HowMuchDoYouFeel_Hopeless_WhenThingsAreBadYouFeelLikeT_1 HowMuchDoYouFeel_Lonely_LikeYouWantMoreSocialConnectio_1 HowMuchDoYouFeel_Humiliated_YouFeelAshamedOrFoolishInT_1 HowMuchDoYouFeel_DesireToAvoid_YouDesireToAvoidPeople__1 HowMuchDoYouFeel_UrgeToUseAlcohol_1 HowMuchDoYouFeel_UrgeToUseHeroin_1 HowMuchDoYouFeel_UrgeToUseCocaine_1 HowMuchDoYouFeel_UrgeToEatSomethingSweet_1 HowMuchDoYouFeel_UrgeToEatSomethingSavory_1 HowMuchDoYouFeel_UrgeToHurtYourself_UrgeToHurtYourBody_1 HowMuchDoYouFeel_UrgeToDie_1 HowMuchDoYouFeel_UrgeToDoSomethingRiskyOrImpulsive_1 HowMuchDoYouFeel_NeedToBeWithFriendsOrFamily_1 IWouldBeAbleToEnjoyThingsThatIUsuallyLike_favoriteMeal_1 ThePastHourDidAnyOfTheFollowingHappen_ISawHeroin_1 ThePastHourDidAnyOfTheFollowingHappen_SomeoneOfferedMeHeroin_1 ThePastHourDidAnyOfTheFollowingHappen_IUsedHeroin_1 wManyBagsDidYouUse__1 ThePastHourDidYouUseAnyOfTheFollowing__1 wMuchMoney_sWorthOfCocaineDidYouHave__1 wManyDrinksDidYouHave__OneDrinkIsACanOfBeer_AGlassOfWine_ASho_1 wManyBenzosDidYouUse__1 wManyJointsDidYouHave__1 atDidYouUse__1 ThePastHourDidAnyOfTheFollowingHappen_IWantedToSeeWhatWouldHa_1 ThePastHourDidAnyOfTheFollowingHappen_OutOfTheBlueIFeltTempte_1 ThePastHourDidAnyOfTheFollowingHappen_IHandled_10OrMoreInCash_1 ereAreYouRightNow__1 ghtBeforeYouStartedThisSurvey_WhoWereYouWith__1 ooseBelowWhoYouWereWith_CheckAllThatApply__1 wCloseOrConnectedDoYouFeelWithThesePeopleRightNow__1 veYouEverUseUsedDrugsWithAtLeastOneOfThesePeopleBefore__1 ghtBeforeYouStartedThisSurvey_WhatWereYouDoing_CheckAllThatAp_1 General_Prompt_SurveySubmittedDate_2 General_Prompt_SurveySubmittedTime_2 HowMuchDoYouFeel_Sad_Unhappy_DownInTheDumps_Miserable__2 HowMuchDoYouFeel_InAGoodMood_2 HowMuchDoYouFeel_ConnectedWithOthers_2 HowMuchDoYouFeel_Psychological_emotionalPain_EmotionsT_2 HowMuchDoYouFeel_Bored_2 HowMuchDoYouFeel_LikeYouNeedToEscape_ThingsAreSoBadYou_2 HowMuchDoYouFeel_Agitated_irritated_YouAreCrawlingOutO_2 HowMuchDoYouFeel_Worried_YouAreThinkingAboutBadThingsT_2 HowMuchDoYouFeel_Anxious_FeelingLikeBadThingsCouldHapp_2 HowMuchDoYouFeel_Energetic_YouFeelAwakeAndWithEnergyTo_2 HowMuchDoYouFeel_Self_hatred_YouHateHowYouAreAsAPerson_2 HowMuchDoYouFeel_Angry_YouFeelAnnoyed_Resentment_OrExa_2 HowMuchDoYouFeel_OnEdge_On_highAlert_Or_onGuard___2 HowMuchDoYouFeel_Numb_YouHaveDifficultyFeelingEmotions_2 HowMuchDoYouFeel_Grateful_ThankfulOrAppreciativeForThe_2 HowMuchDoYouFeel_PhysicalPainOrDiscomfort_2 HowMuchDoYouFeel_Hopeless_WhenThingsAreBadYouFeelLikeT_2 HowMuchDoYouFeel_Lonely_LikeYouWantMoreSocialConnectio_2 HowMuchDoYouFeel_Humiliated_YouFeelAshamedOrFoolishInT_2 HowMuchDoYouFeel_DesireToAvoid_YouDesireToAvoidPeople__2 HowMuchDoYouFeel_UrgeToUseAlcohol_2 HowMuchDoYouFeel_UrgeToUseHeroin_2 HowMuchDoYouFeel_UrgeToUseCocaine_2 HowMuchDoYouFeel_UrgeToEatSomethingSweet_2 HowMuchDoYouFeel_UrgeToEatSomethingSavory_2 HowMuchDoYouFeel_UrgeToHurtYourself_UrgeToHurtYourBody_2 HowMuchDoYouFeel_UrgeToDie_2 HowMuchDoYouFeel_UrgeToDoSomethingRiskyOrImpulsive_2 HowMuchDoYouFeel_NeedToBeWithFriendsOrFamily_2 IWouldBeAbleToEnjoyThingsThatIUsuallyLike_favoriteMeal_2 ThePastHourDidAnyOfTheFollowingHappen_ISawHeroin_2 ThePastHourDidAnyOfTheFollowingHappen_SomeoneOfferedMeHeroin_2 ThePastHourDidAnyOfTheFollowingHappen_IUsedHeroin_2 wManyBagsDidYouUse__2 ThePastHourDidYouUseAnyOfTheFollowing__2 wMuchMoney_sWorthOfCocaineDidYouHave__2 wManyDrinksDidYouHave__OneDrinkIsACanOfBeer_AGlassOfWine_ASho_2 wManyBenzosDidYouUse__2 wManyJointsDidYouHave__2 atDidYouUse__2 ThePastHourDidAnyOfTheFollowingHappen_IWantedToSeeWhatWouldHa_2 ThePastHourDidAnyOfTheFollowingHappen_OutOfTheBlueIFeltTempte_2 ThePastHourDidAnyOfTheFollowingHappen_IHandled_10OrMoreInCash_2 ereAreYouRightNow__2 ghtBeforeYouStartedThisSurvey_WhoWereYouWith__2 ooseBelowWhoYouWereWith_CheckAllThatApply__2 wCloseOrConnectedDoYouFeelWithThesePeopleRightNow__2 veYouEverUseUsedDrugsWithAtLeastOneOfThesePeopleBefore__2 ghtBeforeYouStartedThisSurvey_WhatWereYouDoing_CheckAllThatAp_2 General_Prompt_SurveySubmittedDate_3 General_Prompt_SurveySubmittedTime_3 HowMuchDoYouFeel_Sad_Unhappy_DownInTheDumps_Miserable__3 HowMuchDoYouFeel_InAGoodMood_3 HowMuchDoYouFeel_ConnectedWithOthers_3 HowMuchDoYouFeel_Psychological_emotionalPain_EmotionsT_3 HowMuchDoYouFeel_Bored_3 HowMuchDoYouFeel_LikeYouNeedToEscape_ThingsAreSoBadYou_3 HowMuchDoYouFeel_Agitated_irritated_YouAreCrawlingOutO_3 HowMuchDoYouFeel_Worried_YouAreThinkingAboutBadThingsT_3 HowMuchDoYouFeel_Anxious_FeelingLikeBadThingsCouldHapp_3 HowMuchDoYouFeel_Energetic_YouFeelAwakeAndWithEnergyTo_3 HowMuchDoYouFeel_Self_hatred_YouHateHowYouAreAsAPerson_3 HowMuchDoYouFeel_Angry_YouFeelAnnoyed_Resentment_OrExa_3 HowMuchDoYouFeel_OnEdge_On_highAlert_Or_onGuard___3 HowMuchDoYouFeel_Numb_YouHaveDifficultyFeelingEmotions_3 HowMuchDoYouFeel_Grateful_ThankfulOrAppreciativeForThe_3 HowMuchDoYouFeel_PhysicalPainOrDiscomfort_3 HowMuchDoYouFeel_Hopeless_WhenThingsAreBadYouFeelLikeT_3 HowMuchDoYouFeel_Lonely_LikeYouWantMoreSocialConnectio_3 HowMuchDoYouFeel_Humiliated_YouFeelAshamedOrFoolishInT_3 HowMuchDoYouFeel_DesireToAvoid_YouDesireToAvoidPeople__3 HowMuchDoYouFeel_UrgeToUseAlcohol_3 HowMuchDoYouFeel_UrgeToUseHeroin_3 HowMuchDoYouFeel_UrgeToUseCocaine_3 HowMuchDoYouFeel_UrgeToEatSomethingSweet_3 HowMuchDoYouFeel_UrgeToEatSomethingSavory_3 HowMuchDoYouFeel_UrgeToHurtYourself_UrgeToHurtYourBody_3 HowMuchDoYouFeel_UrgeToDie_3 HowMuchDoYouFeel_UrgeToDoSomethingRiskyOrImpulsive_3 HowMuchDoYouFeel_NeedToBeWithFriendsOrFamily_3 IWouldBeAbleToEnjoyThingsThatIUsuallyLike_favoriteMeal_3 ThePastHourDidAnyOfTheFollowingHappen_ISawHeroin_3 ThePastHourDidAnyOfTheFollowingHappen_SomeoneOfferedMeHeroin_3 ThePastHourDidAnyOfTheFollowingHappen_IUsedHeroin_3 wManyBagsDidYouUse__3 ThePastHourDidYouUseAnyOfTheFollowing__3 wMuchMoney_sWorthOfCocaineDidYouHave__3 wManyDrinksDidYouHave__OneDrinkIsACanOfBeer_AGlassOfWine_ASho_3 wManyBenzosDidYouUse__3 wManyJointsDidYouHave__3 atDidYouUse__3 ThePastHourDidAnyOfTheFollowingHappen_IWantedToSeeWhatWouldHa_3 ThePastHourDidAnyOfTheFollowingHappen_OutOfTheBlueIFeltTempte_3 ThePastHourDidAnyOfTheFollowingHappen_IHandled_10OrMoreInCash_3 ereAreYouRightNow__3 ghtBeforeYouStartedThisSurvey_WhoWereYouWith__3 ooseBelowWhoYouWereWith_CheckAllThatApply__3 wCloseOrConnectedDoYouFeelWithThesePeopleRightNow__3 veYouEverUseUsedDrugsWithAtLeastOneOfThesePeopleBefore__3 ghtBeforeYouStartedThisSurvey_WhatWereYouDoing_CheckAllThatAp_3
____________________________________ ____________________________________ ________________________________________________________ ______________________________ ______________________________________ ________________________________________________________ ________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ___________________________________________________ ________________________________________________________ ________________________________________________________ ___________________________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ___________________________________ __________________________________ ___________________________________ __________________________________________ ___________________________________________ ________________________________________________________ ____________________________ ____________________________________________________ ______________________________________________ ________________________________________________________ __________________________________________________ ______________________________________________________________ ___________________________________________________ _____________________ ________________________________________ _______________________________________ _______________________________________________________________ _______________________ ________________________ _____________________ _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ ____________________________________ _______________________________________________ _______________________________________________________________ ____________________________________________________ _________________________________________________________ ___________________________________________________________________________________________________________________________ ____________________________________ ____________________________________ ________________________________________________________ ______________________________ ______________________________________ ________________________________________________________ ________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ___________________________________________________ ________________________________________________________ ________________________________________________________ ___________________________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ___________________________________ __________________________________ ___________________________________ __________________________________________ ___________________________________________ ________________________________________________________ ____________________________ ____________________________________________________ ______________________________________________ ________________________________________________________ __________________________________________________ ______________________________________________________________ ___________________________________________________ _____________________ ________________________________________ _______________________________________ _______________________________________________________________ _______________________ ________________________ _____________________ _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ ____________________ _______________________________________________ _______________________________________________________________ ____________________________________________________ _________________________________________________________ ___________________________________________________________________________________________________________________________ ____________________________________ ____________________________________ ________________________________________________________ ______________________________ ______________________________________ ________________________________________________________ ________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ___________________________________________________ ________________________________________________________ ________________________________________________________ ___________________________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ________________________________________________________ ___________________________________ __________________________________ ___________________________________ __________________________________________ ___________________________________________ ________________________________________________________ ____________________________ ____________________________________________________ ______________________________________________ ________________________________________________________ __________________________________________________ ______________________________________________________________ ___________________________________________________ _____________________ ________________________________________ _______________________________________ _______________________________________________________________ _______________________ ________________________ _____________________ _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ ____________________ _______________________________________________ _______________________________________________________________ ____________________________________________________ _________________________________________________________ ____________________________________________________________________________________________________________________________________________________
19-May-2021 {'12:09:16'} 5 79 53 28 7 29 49 9 8 63 8 8 6 5 53 75 2 4 3 81 2 10 2 27 49 2 3 0 5 51 {'No' } {'No' } {'No' } NaN {'None'} NaN NaN NaN NaN {'CONDITION_SKIPPED'} {'No' } {'No' } {'Yes'} {'At home' } {'With people in person' } {'Children in your family (e.g. your kids, niece, etc.)' } {'94' } NaN {'Watching TV/listening to music/playing video games,Texting, using social media, or browsing the web' } 19-May-2021 {'13:19:28'} 8 44 86 53 5 57 57 2 4 55 4 17 10 2 74 4 8 2 5 5 6 2 2 61 77 0 0 2 31 79 {'No' } {'No' } {'No' } NaN {'None' } NaN NaN NaN NaN {'CONDITION_SKIPPED'} {'No' } {'No' } {'Yes' } {'At home' } {'With people online/over the phone' } {'Children in your family (e.g. your kids, niece, etc.)' } {'93' } NaN {'Texting, using social media, or browsing the web' } 19-May-2021 {'18:58:10'} 4 77 69 38 8 10 4 3 5 5 67 2 20 8 81 50 3 4 10 57 4 3 2 59 83 1 0 2 34 73 {'No' } {'No' } {'No' } NaN {'None' } NaN NaN NaN NaN {'CONDITION_SKIPPED'} {'No' } {'No' } {'Yes' } {'At home' } {'Alone' } {'Alone,Children in your family (e.g. your kids, niece, etc.)'} {'92' } NaN {'Watching TV/listening to music/playing video games,Texting, using social media, or browsing the web,Video chat (Google Hangout, Skype, FaceTime)'}
20-May-2021 {'10:45:02'} 25 50 51 52 8 26 56 52 48 34 12 26 23 34 55 50 20 4 4 86 14 8 3 53 55 7 2 2 6 2 {'Yes'} {'Yes'} {'No' } NaN {'None'} NaN NaN NaN NaN {'CONDITION_SKIPPED'} {'No' } {'No' } {'Yes'} {'At home' } {'With people in person' } {'Children in your family (e.g. your kids, niece, etc.)' } {'85' } NaN {'Texting, using social media, or browsing the web' } 20-May-2021 {'11:16:23'} 2 46 66 55 2 5 39 41 6 54 0 11 10 8 81 44 1 2 26 69 6 4 2 53 71 0 2 8 10 55 {'No' } {'No' } {'No' } NaN {'None' } NaN NaN NaN NaN {'CONDITION_SKIPPED'} {'No' } {'No' } {'Yes' } {'At home' } {'Alone' } {'Alone' } {'CONDITION_SKIPPED'} NaN {'Texting, using social media, or browsing the web' } 20-May-2021 {'15:49:01'} 4 66 73 51 1 1 4 0 5 4 0 2 0 7 78 10 11 0 13 8 4 5 4 83 74 0 2 0 50 80 {'No' } {'No' } {'No' } NaN {'None' } NaN NaN NaN NaN {'CONDITION_SKIPPED'} {'No' } {'No' } {'Yes' } {'At home' } {'Alone,With people in person'} {'Alone,Children in your family (e.g. your kids, niece, etc.)'} {'90' } NaN {'Texting, using social media, or browsing the web' }
21-May-2021 {'17:20:19'} 0 85 69 47 4 4 1 10 5 49 1 3 10 6 81 6 10 6 9 8 2 2 3 48 51 6 2 6 10 42 {'No' } {'No' } {'No' } NaN {'None'} NaN NaN NaN NaN {'CONDITION_SKIPPED'} {'No' } {'No' } {'Yes'} {'At home' } {'With people in person' } {'Alone,Children in your family (e.g. your kids, niece, etc.)'} {'84' } NaN {'Watching TV/listening to music/playing video games,Texting, using social media, or browsing the web' } 21-May-2021 {'17:34:24'} 6 91 53 5 6 5 10 33 6 21 8 0 14 8 78 36 9 13 9 55 3 2 0 67 67 0 5 6 13 53 {'No' } {'No' } {'No' } NaN {'None' } NaN NaN NaN NaN {'CONDITION_SKIPPED'} {'No' } {'No' } {'Yes' } {'At home' } {'Alone,With people online/over the phone'} {'Alone,Children in your family (e.g. your kids, niece, etc.)'} {'90' } NaN {'Watching TV/listening to music/playing video games,Resting or sleeping' } 21-May-2021 {'19:56:30'} 2 55 73 6 61 23 54 56 33 78 2 5 30 10 65 5 5 5 2 82 7 0 0 51 63 2 0 0 34 49 {'No' } {'No' } {'No' } NaN {'None' } NaN NaN NaN NaN {'CONDITION_SKIPPED'} {'No' } {'No' } {'Yes' } {'At home' } {'With people in person' } {'Children in your family (e.g. your kids, niece, etc.)' } {'83' } NaN {'Watching TV/listening to music/playing video games,Texting, using social media, or browsing the web' }
22-May-2021 {'14:11:41'} 3 69 59 5 1 5 0 38 9 60 3 2 5 4 91 46 0 3 3 74 3 3 3 43 64 0 2 0 2 37 {'No' } {'No' } {'No' } NaN {'None'} NaN NaN NaN NaN {'CONDITION_SKIPPED'} {'No' } {'No' } {'Yes'} {'At home' } {'Alone,With people in person'} {'Alone,Children in your family (e.g. your kids, niece, etc.)'} {'94' } NaN {'Watching TV/listening to music/playing video games,Texting, using social media, or browsing the web,Resting or sleeping'} 22-May-2021 {'16:56:22'} 0 53 71 14 4 2 5 10 3 60 0 10 5 3 70 2 3 23 8 72 2 6 2 56 65 6 0 0 6 45 {'No' } {'Yes' } {'Yes' } NaN {'None' } NaN NaN NaN NaN {'CONDITION_SKIPPED'} {'Yes' } {'Yes' } {'Yes' } {'At home' } {'Alone' } {'Alone' } {'CONDITION_SKIPPED'} NaN {'Texting, using social media, or browsing the web,Resting or sleeping,Socializing/hanging out' } 22-May-2021 {'19:23:20'} 7 71 67 9 6 19 0 21 10 61 1 2 4 3 88 25 2 4 2 68 2 8 5 62 82 2 2 6 5 29 {'Yes' } {'No' } {'Yes' } NaN {'None' } NaN NaN NaN NaN {'CONDITION_SKIPPED'} {'Yes' } {'Yes' } {'Yes' } {'At home' } {'Alone' } {'Alone' } {'CONDITION_SKIPPED'} NaN {'Watching TV/listening to music/playing video games,Resting or sleeping' }
General_Prompts_Stacked.General_Prompt_SurveySubmittedDate_1
ans = 1333×11 char array
'19-May-2021'
'20-May-2021'
'21-May-2021'
'22-May-2021'
'23-May-2021'
'24-May-2021'
'25-May-2021'
'26-May-2021'
'27-May-2021'
'28-May-2021'
'29-May-2021'
'30-May-2021'
'31-May-2021'
'01-Jun-2021'
'02-Jun-2021'
'03-Jun-2021'
'04-Jun-2021'
'05-Jun-2021'
'06-Jun-2021'
'07-Jun-2021'
'08-Jun-2021'
'09-Jun-2021'
'10-Jun-2021'
'11-Jun-2021'
'12-Jun-2021'
'13-Jun-2021'
'14-Jun-2021'
'15-Jun-2021'
'29-Sep-2020'
'30-Sep-2020'
'01-Oct-2020'
'02-Oct-2020'
'03-Oct-2020'
'04-Oct-0020'
'05-Oct-2020'
'06-Oct-0020'
'07-Oct-2020'
'08-Oct-2020'
'09-Oct-2020'
'10-Oct-2020'
'11-Oct-2020'
'12-Oct-2020'
'13-Oct-2020'
'14-Oct-2020'
'15-Oct-2020'
'16-Oct-2020'
'17-Oct-2020'
'18-Oct-0020'
'19-Oct-2020'
'20-Oct-2020'
'21-Oct-2020'
'22-Oct-2020'
'23-Oct-2020'
'24-Oct-2020'
'25-Oct-2020'
'26-Oct-0020'
'27-Oct-2020'
'04-Jun-0021'
'05-Jun-0021'
'06-Jun-0021'
'07-Jun-0021'
'08-Jun-0021'
'09-Jun-0021'
'10-Jun-0021'
'11-Jun-0021'
'12-Jun-0021'
'13-Jun-0021'
'14-Jun-0021'
'15-Jun-0021'
'16-Jun-0021'
'17-Jun-0021'
'18-Jun-0021'
'19-Jun-0021'
'20-Jun-0021'
'21-Jun-0021'
'22-Jun-0021'
'23-Jun-0021'
'24-Jun-0021'
'25-Jun-0021'
'26-Jun-0021'
'27-Jun-0021'
'28-Jun-0021'
'29-Jun-0021'
'30-Jun-0021'
'01-Jul-0021'
'20-May-0021'
'21-May-0021'
'22-May-0021'
'23-May-0021'
'24-May-0021'
'25-May-2021'
'26-May-2021'
'27-May-2021'
'28-May-2021'
'29-May-2021'
'30-May-2021'
'31-May-2021'
'01-Jun-2021'
'02-Jun-2021'
'03-Jun-2021'
'04-Jun-2021'
'05-Jun-2021'
'06-Jun-2021'
'07-Jun-2021'
'08-Jun-2021'
'09-Jun-2021'
'10-Jun-2021'
'11-Jun-2021'
'12-Jun-2021'
'13-Jun-2021'
'14-Jun-2021'
'15-Jun-2021'
'16-Jun-2021'
'06-Jan-2021'
'07-Jan-2021'
'08-Jan-2021'
'09-Jan-2021'
'10-Jan-0021'
'11-Jan-2021'
'12-Jan-2021'
'13-Jan-0021'
'14-Jan-2021'
'15-Jan-2021'
'16-Jan-2021'
'17-Jan-2021'
'18-Jan-2021'
'19-Jan-2021'
'20-Jan-2021'
'21-Jan-2021'
'22-Jan-0021'
'23-Jan-0021'
'24-Jan-0021'
'25-Jan-0021'
'26-Jan-0021'
'27-Jan-2021'
'28-Jan-0021'
'29-Jan-2021'
'30-Jan-2021'
'31-Jan-0021'
'01-Feb-2021'
'02-Feb-0021'
'07-Aug-2020'
'08-Aug-2020'
'09-Aug-2020'
'10-Aug-2020'
'11-Aug-2020'
'12-Aug-2020'
'13-Aug-2020'
'14-Aug-2020'
'15-Aug-2020'
'16-Aug-2020'
'17-Aug-2020'
'18-Aug-2020'
'19-Aug-2020'
'20-Aug-0020'
'21-Aug-0020'
'22-Aug-0020'
'23-Aug-0020'
'24-Aug-0020'
'25-Aug-0020'
'26-Aug-0020'
'27-Aug-0020'
'28-Aug-0020'
'29-Aug-0020'
'30-Aug-0020'
'31-Aug-0020'
'01-Sep-0020'
'02-Sep-0020'
'03-Sep-0020'
'04-Sep-0020'
'05-Sep-2020'
'06-Sep-2020'
'07-Sep-2020'
'08-Sep-2020'
'09-Sep-2020'
'10-Sep-2020'
'11-Sep-2020'
'12-Sep-2020'
'13-Sep-2020'
'14-Sep-2020'
'15-Sep-2020'
'16-Sep-2020'
'17-Sep-2020'
'04-Sep-2020'
'05-Sep-0020'
'06-Sep-2020'
'07-Sep-0020'
'08-Sep-2020'
'09-Sep-0020'
'10-Sep-0020'
'11-Sep-0020'
'12-Sep-2020'
'13-Sep-2020'
'14-Sep-2020'
'15-Sep-2020'
'16-Sep-2020'
'17-Sep-2020'
'18-Sep-0020'
'19-Sep-0020'
'20-Sep-0020'
'21-Sep-2020'
'22-Sep-2020'
'23-Sep-2020'
'24-Sep-2020'
'25-Sep-2020'
'26-Sep-0020'
'27-Sep-2020'
'28-Sep-2020'
'29-Sep-2020'
'30-Sep-2020'
'01-Oct-2020'
'02-Oct-2020'
'03-Oct-2020'
'04-Oct-2020'
'05-Oct-2020'
'20-May-2021'
'21-May-2021'
'22-May-0021'
'23-May-2021'
'24-May-2021'
'25-May-2021'
'26-May-2021'
'27-May-2021'
'28-May-2021'
'29-May-0021'
'30-May-2021'
'31-May-2021'
'01-Jun-2021'
'02-Jun-2021'
'03-Jun-2021'
'04-Jun-0021'
'05-Jun-2021'
'06-Jun-2021'
'07-Jun-2021'
'08-Jun-2021'
'09-Jun-2021'
'10-Jun-2021'
'11-Jun-2021'
'12-Jun-2021'
'13-Jun-2021'
'14-Jun-2021'
'15-Jun-2021'
'16-Jun-0021'
'26-Sep-2020'
'27-Sep-2020'
'28-Sep-2020'
'29-Sep-2020'
'30-Sep-2020'
'01-Oct-2020'
'02-Oct-2020'
'03-Oct-2020'
'04-Oct-2020'
'05-Oct-2020'
'06-Oct-2020'
'07-Oct-2020'
'08-Oct-0020'
'09-Oct-2020'
'10-Oct-2020'
'11-Oct-2020'
'12-Oct-2020'
'13-Oct-2020'
'14-Oct-2020'
'15-Oct-2020'
'16-Oct-2020'
'17-Oct-0020'
'18-Oct-2020'
'19-Oct-2020'
'20-Oct-0020'
'21-Oct-2020'
'22-Oct-2020'
'23-Oct-2020'
'30-Jun-0021'
'01-Jul-2021'
'02-Jul-2021'
'03-Jul-0021'
'04-Jul-0021'
'05-Jul-2021'
'06-Jul-0021'
'07-Jul-0021'
'08-Jul-0021'
'09-Jul-0021'
'10-Jul-0021'
'11-Jul-0021'
'12-Jul-0021'
'13-Jul-0021'
'14-Jul-0021'
'15-Jul-0021'
'16-Jul-0021'
'17-Jul-0021'
'18-Jul-0021'
'19-Jul-0021'
'20-Jul-0021'
'21-Jul-0021'
'22-Jul-0021'
'23-Jul-0021'
'24-Jul-0021'
'25-Jul-0021'
'26-Jul-0021'
'27-Jul-0021'
'02-Oct-2020'
'03-Oct-2020'
'04-Oct-2020'
'05-Oct-2020'
'06-Oct-2020'
'07-Oct-2020'
'08-Oct-2020'
'09-Oct-2020'
'10-Oct-2020'
'11-Oct-2020'
'12-Oct-2020'
'13-Oct-2020'
'14-Oct-2020'
'15-Oct-2020'
'16-Oct-2020'
'17-Oct-2020'
'18-Oct-2020'
'19-Oct-2020'
'20-Oct-2020'
'21-Oct-2020'
'22-Oct-2020'
'23-Oct-2020'
'24-Oct-2020'
'25-Oct-2020'
'26-Oct-2020'
'27-Oct-2020'
'28-Oct-2020'
'29-Oct-2020'
'14-May-2021'
'15-May-2021'
'16-May-2021'
'17-May-2021'
'18-May-2021'
'19-May-2021'
'20-May-2021'
'21-May-2021'
'22-May-2021'
'23-May-2021'
'24-May-2021'
'25-May-2021'
'26-May-2021'
'27-May-2021'
'28-May-2021'
'29-May-2021'
'30-May-2021'
'31-May-2021'
'01-Jun-2021'
'02-Jun-2021'
'03-Jun-2021'
'04-Jun-2021'
'05-Jun-2021'
'06-Jun-2021'
'07-Jun-2021'
'08-Jun-2021'
'09-Jun-0021'
'10-Jun-2021'
'25-May-2021'
'26-May-2021'
'27-May-2021'
'28-May-2021'
'29-May-2021'
'30-May-2021'
'31-May-2021'
'01-Jun-2021'
'02-Jun-2021'
'03-Jun-2021'
'04-Jun-2021'
'05-Jun-2021'
'06-Jun-2021'
'07-Jun-2021'
'08-Jun-2021'
'09-Jun-2021'
'10-Jun-2021'
'11-Jun-2021'
'12-Jun-2021'
'13-Jun-2021'
'14-Jun-2021'
'15-Jun-2021'
'16-Jun-2021'
'17-Jun-2021'
'18-Jun-2021'
'19-Jun-2021'
'20-Jun-2021'
'21-Jun-2021'
'11-Dec-2020'
'12-Dec-0020'
'13-Dec-2020'
'14-Dec-2020'
'15-Dec-2020'
'16-Dec-2020'
'17-Dec-2020'
'18-Dec-2020'
'19-Dec-2020'
'20-Dec-2020'
'21-Dec-2020'
'22-Dec-2020'
'23-Dec-2020'
'24-Dec-0020'
'25-Dec-0020'
'26-Dec-2020'
'27-Dec-2020'
'28-Dec-2020'
'29-Dec-2020'
'30-Dec-2020'
'31-Dec-2020'
'01-Jan-2021'
'02-Jan-0021'
'03-Jan-2021'
'04-Jan-2021'
'05-Jan-2021'
'06-Jan-2021'
'07-Jan-2021'
'28-Oct-2020'
'29-Oct-0020'
'30-Oct-2020'
'31-Oct-2020'
'01-Nov-2020'
'02-Nov-2020'
'03-Nov-2020'
'04-Nov-2020'
'05-Nov-2020'
'06-Nov-2020'
'07-Nov-0020'
'08-Nov-2020'
'09-Nov-2020'
'10-Nov-2020'
'11-Nov-2020'
'12-Nov-2020'
'13-Nov-2020'
'14-Nov-2020'
'15-Nov-2020'
'16-Nov-2020'
'17-Nov-2020'
'18-Nov-2020'
'19-Nov-2020'
'20-Nov-2020'
'21-Nov-2020'
'22-Nov-2020'
'23-Nov-2020'
'24-Nov-2020'
'30-Sep-2020'
'01-Oct-2020'
'02-Oct-2020'
'03-Oct-2020'
'04-Oct-2020'
'05-Oct-2020'
'06-Oct-2020'
'07-Oct-2020'
'08-Oct-2020'
'09-Oct-2020'
'10-Oct-2020'
'11-Oct-2020'
'12-Oct-2020'
'13-Oct-2020'
'14-Oct-0020'
'15-Oct-0020'
'16-Oct-0020'
'17-Oct-0020'
'18-Oct-0020'
'19-Oct-0020'
'20-Oct-0020'
'21-Oct-0020'
'22-Oct-0020'
'23-Oct-0020'
'24-Oct-0020'
'25-Oct-0020'
'26-Oct-0020'
'27-Oct-0020'
'01-Oct-2020'
'02-Oct-2020'
'03-Oct-2020'
'04-Oct-2020'
'05-Oct-2020'
'06-Oct-2020'
'07-Oct-2020'
'08-Oct-2020'
'09-Oct-2020'
'10-Oct-2020'
'11-Oct-2020'
'12-Oct-2020'
'13-Oct-2020'
'14-Oct-2020'
'15-Oct-2020'
'16-Oct-2020'
'17-Oct-2020'
'18-Oct-2020'
'19-Oct-2020'
'20-Oct-2020'
'21-Oct-2020'
'22-Oct-2020'
'23-Oct-2020'
'24-Oct-2020'
'25-Oct-2020'
'26-Oct-2020'
'27-Oct-2020'
'28-Oct-2020'
'28-Oct-2020'
'29-Oct-2020'
'30-Oct-2020'
'31-Oct-2020'
'01-Nov-2020'
'02-Nov-2020'
'03-Nov-2020'
'04-Nov-2020'
'05-Nov-2020'
'06-Nov-2020'
'07-Nov-2020'
'08-Nov-2020'
'09-Nov-2020'
'10-Nov-2020'
'11-Nov-2020'
'12-Nov-2020'
'13-Nov-2020'
'14-Nov-2020'
'15-Nov-2020'
'16-Nov-2020'
'17-Nov-2020'
'18-Nov-2020'
'19-Nov-2020'
'20-Nov-2020'
'21-Nov-2020'
'22-Nov-2020'
'23-Nov-2020'
'24-Nov-2020'
'14-May-2021'
'15-May-2021'
'16-May-2021'
'17-May-2021'
'18-May-2021'
'19-May-2021'
'20-May-2021'
'21-May-2021'
'22-May-2021'
'23-May-2021'
'24-May-2021'
'25-May-2021'
'26-May-2021'
'27-May-2021'
'28-May-2021'
'29-May-2021'
'30-May-2021'
'31-May-2021'
'01-Jun-2021'
'02-Jun-2021'
'03-Jun-2021'
'04-Jun-2021'
'05-Jun-2021'
'06-Jun-2021'
'07-Jun-2021'
'08-Jun-2021'
'09-Jun-2021'
'10-Jun-2021'
'30-Mar-2021'
'31-Mar-2021'
'01-Apr-2021'
'02-Apr-2021'
'03-Apr-2021'
'04-Apr-2021'
'05-Apr-2021'
'06-Apr-2021'
'07-Apr-2021'
'08-Apr-2021'
'09-Apr-2021'
'10-Apr-2021'
'11-Apr-2021'
'12-Apr-2021'
'13-Apr-2021'
'14-Apr-2021'
'15-Apr-2021'
'16-Apr-2021'
'17-Apr-2021'
'18-Apr-2021'
'19-Apr-2021'
'20-Apr-2021'
'21-Apr-2021'
'22-Apr-2021'
'23-Apr-2021'
'24-Apr-2021'
'25-Apr-2021'
'26-Apr-2021'
'30-Mar-2021'
'31-Mar-2021'
'01-Apr-2021'
'02-Apr-2021'
'03-Apr-2021'
'04-Apr-2021'
'05-Apr-2021'
'06-Apr-2021'
'07-Apr-2021'
'08-Apr-2021'
'09-Apr-2021'
'10-Apr-2021'
'11-Apr-2021'
'12-Apr-2021'
'13-Apr-2021'
'14-Apr-2021'
'15-Apr-2021'
'16-Apr-2021'
'17-Apr-2021'
'18-Apr-2021'
'19-Apr-2021'
'20-Apr-2021'
'21-Apr-2021'
'22-Apr-2021'
'23-Apr-2021'
'24-Apr-2021'
'25-Apr-2021'
'26-Apr-2021'
'07-Apr-2021'
'08-Apr-2021'
'09-Apr-2021'
'10-Apr-2021'
'11-Apr-2021'
'12-Apr-2021'
'13-Apr-2021'
'14-Apr-2021'
'15-Apr-2021'
'16-Apr-2021'
'17-Apr-2021'
'18-Apr-2021'
'19-Apr-2021'
'20-Apr-2021'
'21-Apr-2021'
'22-Apr-2021'
'23-Apr-2021'
'24-Apr-2021'
'25-Apr-2021'
'26-Apr-2021'
'27-Apr-2021'
'28-Apr-2021'
'29-Apr-2021'
'30-Apr-2021'
'01-May-2021'
'02-May-2021'
'03-May-2021'
'04-May-2021'
'28-Oct-2020'
'29-Oct-2020'
'30-Oct-0020'
'31-Oct-2020'
'01-Nov-2020'
'02-Nov-2020'
'03-Nov-2020'
'04-Nov-2020'
'05-Nov-2020'
'06-Nov-2020'
'07-Nov-2020'
'08-Nov-2020'
'09-Nov-2020'
'10-Nov-2020'
'11-Nov-2020'
'12-Nov-2020'
'13-Nov-2020'
'14-Nov-2020'
'15-Nov-2020'
'16-Nov-2020'
'17-Nov-2020'
'18-Nov-2020'
'19-Nov-2020'
'20-Nov-2020'
'21-Nov-2020'
'22-Nov-2020'
'23-Nov-2020'
'24-Nov-2020'
'05-Sep-0020'
'06-Sep-2020'
'07-Sep-2020'
'08-Sep-2020'
'09-Sep-2020'
'10-Sep-2020'
'11-Sep-2020'
'12-Sep-2020'
'13-Sep-2020'
'14-Sep-2020'
'15-Sep-2020'
'16-Sep-2020'
'17-Sep-2020'
'18-Sep-2020'
'19-Sep-2020'
'20-Sep-2020'
'21-Sep-2020'
'22-Sep-2020'
'23-Sep-2020'
'24-Sep-2020'
'25-Sep-2020'
'26-Sep-2020'
'27-Sep-2020'
'28-Sep-2020'
'29-Sep-2020'
'30-Sep-2020'
'01-Oct-2020'
'02-Oct-2020'
'09-Oct-2020'
'10-Oct-2020'
'11-Oct-2020'
'12-Oct-2020'
'13-Oct-2020'
'14-Oct-2020'
'15-Oct-2020'
'16-Oct-2020'
'17-Oct-2020'
'18-Oct-2020'
'19-Oct-2020'
'20-Oct-2020'
'21-Oct-2020'
'22-Oct-2020'
'23-Oct-2020'
'24-Oct-2020'
'25-Oct-2020'
'26-Oct-2020'
'27-Oct-2020'
'28-Oct-2020'
'29-Oct-2020'
'30-Oct-2020'
'31-Oct-2020'
'01-Nov-2020'
'02-Nov-2020'
'03-Nov-2020'
'04-Nov-2020'
'05-Nov-2020'
'04-Sep-2020'
'05-Sep-2020'
'06-Sep-2020'
'07-Sep-2020'
'08-Sep-2020'
'09-Sep-2020'
'10-Sep-2020'
'11-Sep-2020'
'12-Sep-2020'
'13-Sep-2020'
'14-Sep-2020'
'15-Sep-2020'
'16-Sep-2020'
'17-Sep-2020'
'18-Sep-2020'
'19-Sep-2020'
'20-Sep-2020'
'21-Sep-2020'
'22-Sep-2020'
'23-Sep-2020'
'24-Sep-2020'
'25-Sep-2020'
'26-Sep-2020'
'27-Sep-2020'
'28-Sep-2020'
'29-Sep-2020'
'30-Sep-2020'
'01-Oct-2020'
'05-Aug-2020'
'06-Aug-2020'
'07-Aug-2020'
'08-Aug-2020'
'09-Aug-2020'
'10-Aug-2020'
'11-Aug-2020'
'12-Aug-2020'
'13-Aug-2020'
'14-Aug-2020'
'15-Aug-2020'
'16-Aug-2020'
'17-Aug-2020'
'18-Aug-2020'
'19-Aug-2020'
'20-Aug-0020'
'21-Aug-0020'
'22-Aug-0020'
'23-Aug-0020'
'24-Aug-0020'
'25-Aug-0020'
'26-Aug-0020'
'27-Aug-0020'
'28-Aug-0020'
'29-Aug-0020'
'30-Aug-0020'
'31-Aug-0020'
'01-Sep-0020'
'02-Sep-0020'
'03-Sep-0020'
'04-Sep-0020'
'05-Sep-0020'
'06-Sep-0020'
'07-Sep-0020'
'08-Sep-0020'
'09-Sep-0020'
'10-Sep-0020'
'11-Sep-0020'
'12-Sep-0020'
'13-Sep-0020'
'14-Sep-0020'
'15-Sep-0020'
'16-Sep-0020'
'17-Sep-0020'
'18-Sep-0020'
'19-Sep-0020'
'01-Apr-2021'
'02-Apr-2021'
'03-Apr-2021'
'04-Apr-2021'
'05-Apr-2021'
'06-Apr-2021'
'07-Apr-2021'
'08-Apr-2021'
'09-Apr-2021'
'10-Apr-2021'
'11-Apr-2021'
'12-Apr-2021'
'13-Apr-2021'
'14-Apr-2021'
'15-Apr-2021'
'16-Apr-2021'
'17-Apr-2021'
'18-Apr-2021'
'19-Apr-2021'
'20-Apr-2021'
'21-Apr-2021'
'22-Apr-2021'
'23-Apr-2021'
'24-Apr-2021'
'25-Apr-2021'
'26-Apr-2021'
'27-Apr-2021'
'28-Apr-2021'
'31-Mar-0021'
'01-Apr-0021'
'02-Apr-0021'
'03-Apr-0021'
'04-Apr-0021'
'05-Apr-0021'
'06-Apr-0021'
'07-Apr-0021'
'08-Apr-0021'
'09-Apr-0021'
'10-Apr-0021'
'11-Apr-0021'
'12-Apr-0021'
'13-Apr-0021'
'14-Apr-0021'
'15-Apr-0021'
'16-Apr-0021'
'17-Apr-0021'
'18-Apr-0021'
'19-Apr-0021'
'20-Apr-0021'
'21-Apr-0021'
'22-Apr-0021'
'23-Apr-0021'
'24-Apr-0021'
'25-Apr-0021'
'26-Apr-0021'
'27-Apr-0021'
'30-Mar-2021'
'31-Mar-2021'
'01-Apr-2021'
'02-Apr-2021'
'03-Apr-2021'
'04-Apr-2021'
'05-Apr-2021'
'06-Apr-2021'
'07-Apr-2021'
'08-Apr-2021'
'09-Apr-2021'
'10-Apr-2021'
'11-Apr-2021'
'12-Apr-2021'
'13-Apr-2021'
'14-Apr-2021'
'15-Apr-2021'
'16-Apr-2021'
'17-Apr-2021'
'18-Apr-2021'
'19-Apr-2021'
'20-Apr-2021'
'21-Apr-2021'
'22-Apr-2021'
'23-Apr-2021'
'24-Apr-2021'
'25-Apr-0021'
'26-Apr-2021'
'11-Mar-0021'
'12-Mar-2021'
'13-Mar-0021'
'14-Mar-2021'
'15-Mar-2021'
'16-Mar-2021'
'17-Mar-2021'
'18-Mar-0021'
'19-Mar-2021'
'20-Mar-2021'
'21-Mar-2021'
'22-Mar-2021'
'23-Mar-2021'
'24-Mar-2021'
'25-Mar-2021'
'26-Mar-2021'
'27-Mar-2021'
'28-Mar-2021'
'29-Mar-2021'
'30-Mar-0021'
'31-Mar-2021'
'01-Apr-2021'
'02-Apr-2021'
'03-Apr-2021'
'04-Apr-2021'
'05-Apr-2021'
'06-Apr-2021'
'07-Apr-2021'
'02-Jun-2021'
'03-Jun-2021'
'04-Jun-2021'
'05-Jun-2021'
'06-Jun-2021'
'07-Jun-2021'
'08-Jun-2021'
'09-Jun-2021'
'10-Jun-2021'
'11-Jun-2021'
'12-Jun-2021'
'13-Jun-2021'
'14-Jun-2021'
'15-Jun-2021'
'16-Jun-2021'
'17-Jun-2021'
'18-Jun-2021'
'19-Jun-2021'
'20-Jun-2021'
'21-Jun-2021'
'22-Jun-2021'
'23-Jun-2021'
'24-Jun-2021'
'25-Jun-2021'
'26-Jun-2021'
'27-Jun-2021'
'28-Jun-2021'
'29-Jun-2021'
'10-Sep-2020'
'11-Sep-2020'
'12-Sep-2020'
'13-Sep-2020'
'14-Sep-2020'
'15-Sep-2020'
'16-Sep-2020'
'17-Sep-2020'
'18-Sep-2020'
'19-Sep-2020'
'20-Sep-2020'
'21-Sep-2020'
'22-Sep-2020'
'23-Sep-2020'
'24-Sep-2020'
'25-Sep-2020'
'26-Sep-2020'
'27-Sep-2020'
'28-Sep-2020'
'29-Sep-2020'
'30-Sep-2020'
'01-Oct-2020'
'02-Oct-2020'
'03-Oct-2020'
'04-Oct-2020'
'05-Oct-2020'
'06-Oct-2020'
'07-Oct-2020'
'16-Sep-2020'
'17-Sep-2020'
'18-Sep-2020'
'19-Sep-0020'
'20-Sep-2020'
'21-Sep-2020'
'22-Sep-2020'
'23-Sep-0020'
'24-Sep-2020'
'25-Sep-2020'
'26-Sep-2020'
'27-Sep-2020'
'28-Sep-2020'
'29-Sep-0020'
'30-Sep-2020'
'01-Oct-2020'
'02-Oct-2020'
'03-Oct-2020'
'04-Oct-0020'
'05-Oct-0020'
'06-Oct-2020'
'07-Oct-2020'
'08-Oct-0020'
'09-Oct-0020'
'10-Oct-0020'
'11-Oct-0020'
'12-Oct-0020'
'13-Oct-0020'
'19-Nov-0020'
'20-Nov-2020'
'21-Nov-2020'
'22-Nov-2020'
'23-Nov-0020'
'24-Nov-0020'
'25-Nov-2020'
'26-Nov-0020'
'27-Nov-0020'
'28-Nov-0020'
'29-Nov-2020'
'30-Nov-0020'
'01-Dec-0020'
'02-Dec-0020'
'03-Dec-0020'
'04-Dec-0020'
'05-Dec-0020'
'06-Dec-0020'
'07-Dec-0020'
'08-Dec-0020'
'09-Dec-0020'
'10-Dec-2020'
'11-Dec-0020'
'12-Dec-0020'
'13-Dec-0020'
'14-Dec-0020'
'15-Dec-0020'
'16-Dec-0020'
'05-Nov-2020'
'06-Nov-2020'
'07-Nov-2020'
'08-Nov-2020'
'09-Nov-2020'
'10-Nov-0020'
'11-Nov-2020'
'12-Nov-0020'
'13-Nov-0020'
'14-Nov-2020'
'15-Nov-0020'
'16-Nov-2020'
'17-Nov-2020'
'18-Nov-2020'
'19-Nov-0020'
'20-Nov-0020'
'21-Nov-2020'
'22-Nov-2020'
'23-Nov-2020'
'24-Nov-2020'
'25-Nov-0020'
'26-Nov-2020'
'27-Nov-2020'
'28-Nov-2020'
'29-Nov-0020'
'30-Nov-2020'
'01-Dec-2020'
'02-Dec-2020'
'24-Mar-2021'
'25-Mar-2021'
'26-Mar-0021'
'27-Mar-0021'
'28-Mar-0021'
'29-Mar-0021'
'30-Mar-0021'
'31-Mar-0021'
'01-Apr-2021'
'02-Apr-0021'
'03-Apr-0021'
'04-Apr-0021'
'05-Apr-0021'
'06-Apr-0021'
'07-Apr-2021'
'08-Apr-0021'
'09-Apr-2021'
'10-Apr-0021'
'11-Apr-0021'
'12-Apr-2021'
'13-Apr-2021'
'14-Apr-0021'
'15-Apr-0021'
'16-Apr-0021'
'17-Apr-0021'
'18-Apr-0021'
'19-Apr-0021'
'20-Apr-2021'
'21-Apr-0021'
'22-Apr-0021'
'23-Apr-0021'
'24-Apr-0021'
'25-Apr-0021'
'26-Apr-0021'
'27-Apr-0021'
'04-Dec-2020'
'05-Dec-2020'
'06-Dec-2020'
'07-Dec-2020'
'08-Dec-2020'
'09-Dec-2020'
'10-Dec-2020'
'11-Dec-2020'
'12-Dec-2020'
'13-Dec-0020'
'14-Dec-0020'
'15-Dec-2020'
'16-Dec-2020'
'17-Dec-0020'
'18-Dec-0020'
'19-Dec-0020'
'20-Dec-0020'
'21-Dec-2020'
'22-Dec-0020'
'23-Dec-2020'
'24-Dec-2020'
'25-Dec-0020'
'26-Dec-2020'
'27-Dec-2020'
'28-Dec-0020'
'29-Dec-0020'
'30-Dec-2020'
'31-Dec-2020'
'10-Dec-2020'
'11-Dec-2020'
'12-Dec-2020'
'13-Dec-2020'
'14-Dec-0020'
'15-Dec-2020'
'16-Dec-2020'
'17-Dec-2020'
'18-Dec-2020'
'19-Dec-2020'
'20-Dec-0020'
'21-Dec-0020'
'22-Dec-0020'
'23-Dec-0020'
'24-Dec-2020'
'25-Dec-2020'
'26-Dec-2020'
'27-Dec-2020'
'28-Dec-2020'
'29-Dec-2020'
'30-Dec-0020'
'31-Dec-0020'
'01-Jan-2021'
'02-Jan-2021'
'03-Jan-2021'
'04-Jan-2021'
'05-Jan-2021'
'06-Jan-0021'
'18-May-0021'
'19-May-2021'
'20-May-2021'
'21-May-2021'
'22-May-2021'
'23-May-2021'
'24-May-0021'
'25-May-2021'
'26-May-2021'
'27-May-2021'
'28-May-0021'
'29-May-2021'
'30-May-2021'
'31-May-0021'
'01-Jun-0021'
'02-Jun-2021'
'03-Jun-2021'
'04-Jun-2021'
'05-Jun-2021'
'06-Jun-0021'
'07-Jun-0021'
'08-Jun-2021'
'09-Jun-2021'
'10-Jun-2021'
'11-Jun-0021'
'12-Jun-0021'
'13-Jun-0021'
'14-Jun-2021'
'02-Jun-2021'
'03-Jun-2021'
'04-Jun-2021'
'05-Jun-2021'
'06-Jun-2021'
'07-Jun-2021'
'08-Jun-2021'
'09-Jun-2021'
'10-Jun-2021'
'11-Jun-2021'
'12-Jun-2021'
'13-Jun-2021'
'14-Jun-2021'
'15-Jun-2021'
'16-Jun-2021'
'17-Jun-2021'
'18-Jun-2021'
'19-Jun-2021'
'20-Jun-2021'
'21-Jun-2021'
'22-Jun-2021'
'23-Jun-2021'
'24-Jun-2021'
'25-Jun-2021'
'26-Jun-2021'
'27-Jun-2021'
'28-Jun-2021'
'29-Jun-2021'
'11-Mar-2021'
'12-Mar-2021'
'13-Mar-2021'
'14-Mar-2021'
'15-Mar-2021'
'16-Mar-0021'
'17-Mar-2021'
'18-Mar-2021'
'19-Mar-2021'
'20-Mar-2021'
'21-Mar-2021'
'22-Mar-2021'
'23-Mar-2021'
'24-Mar-2021'
'25-Mar-2021'
'26-Mar-2021'
'27-Mar-2021'
'28-Mar-2021'
'29-Mar-2021'
'30-Mar-2021'
'31-Mar-2021'
'01-Apr-2021'
'02-Apr-2021'
'03-Apr-2021'
'04-Apr-2021'
'05-Apr-2021'
'06-Apr-2021'
'07-Apr-2021'
'07-Jul-2021'
'08-Jul-0021'
'09-Jul-2021'
'10-Jul-2021'
'11-Jul-2021'
'12-Jul-2021'
'13-Jul-0021'
'14-Jul-0021'
'15-Jul-0021'
'16-Jul-2021'
'17-Jul-2021'
'18-Jul-0021'
'19-Jul-2021'
'20-Jul-2021'
'21-Jul-2021'
'22-Jul-0021'
'23-Jul-2021'
'24-Jul-2021'
'25-Jul-2021'
'26-Jul-2021'
'27-Jul-2021'
'28-Jul-2021'
'29-Jul-2021'
'30-Jul-2021'
'31-Jul-2021'
'01-Aug-2021'
'02-Aug-2021'
'03-Aug-2021'
'07-Jul-2021'
'08-Jul-2021'
'09-Jul-2021'
'10-Jul-2021'
'11-Jul-2021'
'12-Jul-2021'
'13-Jul-2021'
'14-Jul-2021'
'15-Jul-2021'
'16-Jul-2021'
'17-Jul-2021'
'18-Jul-2021'
'19-Jul-2021'
'20-Jul-2021'
'21-Jul-2021'
'22-Jul-2021'
'23-Jul-2021'
'24-Jul-2021'
'25-Jul-2021'
'26-Jul-2021'
'27-Jul-2021'
'28-Jul-2021'
'29-Jul-2021'
'30-Jul-2021'
'31-Jul-2021'
'01-Aug-2021'
'02-Aug-2021'
'03-Aug-2021'
'08-Jul-2021'
'09-Jul-2021'
'10-Jul-2021'
'11-Jul-2021'
'12-Jul-0021'
'13-Jul-2021'
'14-Jul-2021'
'15-Jul-2021'
'16-Jul-2021'
'17-Jul-2021'
'18-Jul-2021'
'19-Jul-2021'
'20-Jul-2021'
'21-Jul-2021'
'22-Jul-2021'
'23-Jul-2021'
'24-Jul-2021'
'25-Jul-2021'
'26-Jul-2021'
'27-Jul-2021'
'28-Jul-2021'
'29-Jul-2021'
'30-Jul-2021'
'31-Jul-2021'
'01-Aug-2021'
'02-Aug-2021'
'03-Aug-2021'
'04-Aug-2021'
'06-Aug-2021'
'07-Aug-0021'
'08-Aug-2021'
'09-Aug-2021'
'10-Aug-2021'
'11-Aug-2021'
'12-Aug-0021'
'13-Aug-0021'
'14-Aug-2021'
'15-Aug-2021'
'16-Aug-2021'
'17-Aug-0021'
'18-Aug-2021'
'19-Aug-2021'
'20-Aug-2021'
'21-Aug-0021'
'22-Aug-0021'
'23-Aug-0021'
'24-Aug-2021'
'25-Aug-0021'
'26-Aug-2021'
'27-Aug-2021'
'28-Aug-2021'
'29-Aug-2021'
'30-Aug-0021'
'31-Aug-2021'
'01-Sep-2021'
'02-Sep-2021'
'03-Sep-0021'
7 个评论
BA
2022-7-25
Yeah, but this is within a script of mine. So the script creates a table called Unstacked. I just used 'writetable()' to get this excel sheet.
Can't readtable a variable saved in workspace
BA
2022-7-25
Sorry about that, how about now?
I believe this is the right version.
The reason I want this script to work is because I'm trying to flip a few of the dates in my dataset. If you scroll down the table, you will see a few of the dates in the dataset are like 0202 instead of 2020. I want to split those specific dates and this was the code I was trying to run:
%Fix General Prompts Flipped Dates
dates = General_Prompts_Stacked.General_Prompt_SurveySubmittedDate_1;
c = split(dates, '/');
c = strrep(c, '1202', '2021');
datesNew = join(c, '/');
Each time I run it, I get this error
Error using split
First argument must be text.
Error in EMA_StackGeneralPrompts (line 121)
c = split(dates, '/');
So I assumed the error was occuring because for the split function, the cell needs to be a char. I believe the .mat I sent now has the table as cells and not chars. I want the first column to be chars so I can run my code.
Siddharth Bhutiya
2022-7-28
Please avoid using legacy functionality like datenum, datestr, etc. and alway prefer using datetime and its surrounding functionality. The legacy functions had their own pitfalls and more modern types like datetime were specifically created to provide more robust support for working with dates and times. See my answer below that does this using datetime methods.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!发生错误
由于页面发生更改,无法完成操作。请重新加载页面以查看其更新后的状态。
您也可以从以下列表中选择网站:
如何获得最佳网站性能
选择中国网站(中文或英文)以获得最佳网站性能。其他 MathWorks 国家/地区网站并未针对您所在位置的访问进行优化。
美洲
- América Latina (Español)
- Canada (English)
- United States (English)
欧洲
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom(English)
亚太
- Australia (English)
- India (English)
- New Zealand (English)
- 中国
- 日本Japanese (日本語)
- 한국Korean (한국어)