topic Re: Prompt & Date/Time variable not match. in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompt-Date-Time-variable-not-match/m-p/203722#M15242 <HTML><HEAD></HEAD><BODY><P>Your prompt type is Date, but you have a date time variable. There should be a prompt time that is date time as well. </P><P></P><P>To answer your question you can use the datepart function to get the date only portion from a date time variable. There are a variety of locations where this could be implemented. </P></BODY></HTML> Tue, 17 Mar 2015 19:32:14 GMT Reeza 2015-03-17T19:32:14Z Prompt & Date/Time variable not match. https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompt-Date-Time-variable-not-match/m-p/203721#M15241 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P>How do I create a new column where the time stamp is removed?&nbsp; Please see the image below for how the column, IGTAccountCreated, is structured.</P><P><IMG alt="Capture.PNG" class="jive-image" src="https://communities.sas.com/legacyfs/online/9595_Capture.PNG" /></P><P>I want a new column with the time stamp removed.&nbsp; How I go about that?</P><P>I need the time stamp removed because Prompt Manager does not recognize time stamp at the end of the date.&nbsp; It only recognize by this format: "March 17, 2015". See image below for my prompt setting.</P><P><IMG alt="Capture1.PNG" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/9596_Capture1.PNG" width="450" /></P><P>I formatted IGTAccountCreated to "01Jan14".I know the prompt worked because when I ran the process it does not gave me an error but no data shown.</P></BODY></HTML> Tue, 17 Mar 2015 19:24:45 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompt-Date-Time-variable-not-match/m-p/203721#M15241 sdang 2015-03-17T19:24:45Z Re: Prompt & Date/Time variable not match. https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompt-Date-Time-variable-not-match/m-p/203722#M15242 <HTML><HEAD></HEAD><BODY><P>Your prompt type is Date, but you have a date time variable. There should be a prompt time that is date time as well. </P><P></P><P>To answer your question you can use the datepart function to get the date only portion from a date time variable. There are a variety of locations where this could be implemented. </P></BODY></HTML> Tue, 17 Mar 2015 19:32:14 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompt-Date-Time-variable-not-match/m-p/203722#M15242 Reeza 2015-03-17T19:32:14Z