Prompt & Date/Time variable not match.

[sdang]

Hi,

How do I create a new column where the time stamp is removed?  Please see the image below for how the column, IGTAccountCreated, is structured.

I want a new column with the time stamp removed.  How I go about that?

I need the time stamp removed because Prompt Manager does not recognize time stamp at the end of the date.  It only recognize by this format: "March 17, 2015". See image below for my prompt setting.

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.

[Reeza · Accepted solution]

Your prompt type is Date, but you have a date time variable. There should be a prompt time that is date time as well.

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.