Forcing date format in load

sibrulotte — Sat, 27 Nov 2021 21:20:13 GMT

I do believe I'm using the correct formula to accomplish the task of forcing my field to be YYYY-MM-DD:

Date(Date#(dtDelivered,'YYYY.MM.DD hh:mm:ss'), 'YYYY-MM-DD hh:mm:ss') as dtDelivered,
Date(Date#(dtDelivered,'YYYY.MM.DD hh:mm:ss'), 'YYYY-MM-DD') as Date_envois_force

Alas, Date_envois is treated like it has multiple values, the exact same that we're there before forcing it to the correct format:

What should I be doing to obtain only 2021-05-05 ?!?

Re: Forcing date format in load

stevejoyce — Sat, 27 Nov 2021 21:32:40 GMT

date/timestamps are dual field type, so despite it having same text displayed, it's still different values due to timestamp. you need to alter the value (ex. Floor())

Date(Floor(Date#(dtDelivered,'YYYY.MM.DD hh:mm:ss')), 'YYYY-MM-DD') as Date_envois_force

topic Re: Forcing date format in load in QlikView

Forcing date format in load

Re: Forcing date format in load