Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Not applicable

Convert DateTime to Date

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Valued Contributor III

Re: Convert DateTime to Date

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

from xyz.qvw;

View solution in original post

5 Replies
Highlighted
Valued Contributor III

Re: Convert DateTime to Date

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

from xyz.qvw;

View solution in original post

Highlighted

Re: Convert DateTime to Date

‌DayName(OrderDate)

or

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

Highlighted
Not applicable

Re: Convert DateTime to Date

Thx

Highlighted
Not applicable

Re: Convert DateTime to Date

Thank you

Highlighted

Re: Convert DateTime to Date

‌you're welcome

regards

Marco