Converting the Excel date time format to Date only format.

Converting the Excel date time format to Date only format.

There are number of times when we encounter Date in the form “date and time”.

E.g.

Typically when a user extracts data from a tool to calculate metrics, the date fields “Created Date” and “Updated Date” are in the format DATE and TIME. For some reason, we would like to have these date fields converted to DATE ONLY fields.

How can we do convert this DATE TIME field value to DATE only value?

Continue reading

Advertisements