remocve time from date field

[#1]

hi ,

Iahve a date field with data as" Apr  9 2014 12:00AM". I need help iin converting it into "09-04-2014"

Thanks in advance!!

[alexandros17]

Date(myFieldDate)

[tresesco]

Use Floor(), like:

Load

Date(Floor(YourField)) as Date

[crusader_]

LOAD

     date(floor(YourDateField),'DD-MM-YYYY') as YourDate

HTH

Andrei

[its_anandrjs]

Try with below scripts

Date(Date(YourDateField,'MMM  D YYYY hh:mm TT'),'DD-MM-YYYY')

Or

Date(Date#(YourDateField,'MMM  D YYYY hh:mm TT'),'DD-MM-YYYY')

Or

Date(YourDateField,'DD-MM-YYYY')

[jagan]

Hi,

Try like this

LOAD

*,

Date(Date#(DateDimensionName, 'MMM D YYYY hh:mmTT'), 'DD-MM-YYYY')

FROM DataSource;

Replace DateDimensionName with your date dimension name.

Regards,

Jagan.