Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER 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
Partner

Date(myFieldDate)

tresesco
MVP
MVP

Use Floor(), like:

Load

Date(Floor(YourField)) as Date

crusader_
Partner
Partner

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

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.