https://communities.sas.com/t5/New-SAS-User/format-the-Date/m-p/833131#M35754 <P>I have the dataset:</P><P>20SEP22:10:00:00</P><P>21SEP22:13:30:00</P><P>19SEP22:13:30:00</P><P>&nbsp;</P><P>I want the dataset with following format:</P><P>09/20/2022</P><P>09/21/2022</P><P>09/19/2022</P><P>&nbsp;</P><P>thank in advance</P> Tue, 13 Sep 2022 13:47:07 GMT Smitha9 2022-09-13T13:47:07Z https://communities.sas.com/t5/New-SAS-User/format-the-Date/m-p/833131#M35754 <P>I have the dataset:</P><P>20SEP22:10:00:00</P><P>21SEP22:13:30:00</P><P>19SEP22:13:30:00</P><P>&nbsp;</P><P>I want the dataset with following format:</P><P>09/20/2022</P><P>09/21/2022</P><P>09/19/2022</P><P>&nbsp;</P><P>thank in advance</P> Tue, 13 Sep 2022 13:47:07 GMT https://communities.sas.com/t5/New-SAS-User/format-the-Date/m-p/833131#M35754 Smitha9 2022-09-13T13:47:07Z https://communities.sas.com/t5/New-SAS-User/format-the-Date/m-p/833135#M35755 <P>Use format DTDATE to produce dates like 20SEP2022</P> <P>&nbsp;</P> <P>If you need exactly&nbsp;<SPAN>09/20/2022 then you need to use the DATEPART function on your date/time variable and then format ddmmyy10.</SPAN></P> Tue, 13 Sep 2022 14:21:29 GMT https://communities.sas.com/t5/New-SAS-User/format-the-Date/m-p/833135#M35755 PaigeMiller 2022-09-13T14:21:29Z