Forcing date format in load

[sibrulotte]

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 ?!?

[stevejoyce · Accepted solution]

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