topic Re: Convert DateTime to Date in QlikView

Convert DateTime to Date

Thu, 13 Aug 2015 18:17:26 GMT

How can I convert DateTime (Field Order Date) into Date (DD/MM/YYYY) with a script ?

Qrishna — Thu, 13 Aug 2015 18:24:21 GMT

load date(orderdate,'M/D/YYYY') as OrderDate

from xyz.qvw;

MarcoWedel — Thu, 13 Aug 2015 18:29:41 GMT

‌DayName(OrderDate)

Date(Floor(OrderDate))

or if your default DateFormat is different from the required one:

Date(Floor(OrderDate),'DD/MM/YYYY')

you maybe can skip the floor function as your sample data always has 00:00:00 as time.

regards

Marco

Thu, 13 Aug 2015 18:32:50 GMT

Thx

Thu, 13 Aug 2015 18:33:16 GMT

Thank you

MarcoWedel — Thu, 13 Aug 2015 18:34:06 GMT

‌you're welcome

regards

Marco