How do you convert all the dates in a table within a column to a character?

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 '/'

Answer 1

[Siddharth Bhutiya]

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"
    

[BA]

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!

Answer 2

[Chunru]

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'

[BA]

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

[Chunru]

Can you attach your worksapce variable as .mat file in that case?

[BA]

Here you go!

[Chunru]

But they are still in cell array of chars.

[BA]

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.

[Chunru]

See above.

[Siddharth Bhutiya]

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.