Script

[mario-sarkis]

hey all ,

need help and this is my Question :

i have this Field

DateTime

  6/1/2014 6:30:20PM

  6/1/2015 7:30:20AM

10/1/2013 8:30:20PM

   6/1/2015 5:30:20PM

   8/1/2012 6:30:20PM

This an example of a field i have, how can i extract the Date and time separetly in the Script

i used already this >>>>>date(floor(timestamp#(Interaction_Dttm,'M/D/YYYY h:mm:ssTT')))  as Date

But it give me an null Field .

Hope anyone Can help in this

Thank you in advance.

[jonathandienst]

Date(Floor(Date#(DateTime, 'M/D/YYYY h:mm:ssTT'))) As Date,

Time(Frac(Date#(DateTime, 'M/D/YYYY h:mm:ssTT'))) As Time

[jonathandienst]

Have you got leading spaces in DateTime?

Date(Floor(Date#(Trim(DateTime), 'M/D/YYYY h:mm:ssTT'))) As Date,

Time(Frac(Date#(Trim(DateTime), 'M/D/YYYY h:mm:ssTT'))) As Time

[mario-sarkis]

HI Jonathan

it still give me an empty fields

but when i put ur expression in the list BOX that contain The DateTime

it Give me like this

DateTime

6/1/2014-

  6/1/2015 -

10/1/2013 -

6/1/2015 -

   8/1/2012 -

can you help More ?

[MayilVahanan]

Hi

Try like this

Load DateTime, Date(Floor(Date#(Date, 'M/D/YYYY h:mm:ssTT'))) AS Date, Time(Frac(Date#(Date, 'M/D/YYYY h:mm:ssTT')),'h:mm:ss') AS Time;

Load *, Trim(DateTime) As Date Inline

[

DateTime

  6/1/2014 6:30:20PM

  6/1/2015 7:30:20AM

10/1/2013 8:30:20PM

   6/1/2015 5:30:20PM

   8/1/2012 6:30:20PM

];

[mario-sarkis]

Hi Mayil Date Time is already a field that i have in my data i didnt understand the INLINE part please can you explain and why in your opinion while using the function that u gave the new field shows empty

Thank you hope you can help