Convert DateTime to Date

[#1]

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

[Qrishna · Accepted solution]

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

from xyz.qvw;

[MarcoWedel]

‌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

[#4]

Thx

[#5]

Thank you

[MarcoWedel]

‌you're welcome

regards

Marco