Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

remocve time from date field

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!!

5 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Date(myFieldDate)

tresesco
MVP
MVP

Use Floor(), like:

Load

Date(Floor(YourField)) as Date

crusader_
Partner - Specialist
Partner - Specialist

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
Luminary Alumni
Luminary Alumni

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.