Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: remocve time from date field

Date(myFieldDate)

MVP
MVP

Re: remocve time from date field

Use Floor(), like:

Load

Date(Floor(YourField)) as Date

crusader_
Valued Contributor

Re: remocve time from date field

LOAD

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

HTH

Andrei

Re: remocve time from date field

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')

MVP
MVP

Re: remocve time from date field

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.

Community Browser