Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I convert DateTime (Field Order Date) into Date (DD/MM/YYYY) with a script ?
load date(orderdate,'M/D/YYYY') as OrderDate
from xyz.qvw;
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
Thx
Thank you
you're welcome
regards
Marco