Date Formatting Option: dd.MM.yyyy

Carsten Lempert shared this idea 1 year ago
Idea Logged

Date Format

  • Default in Germany is dd.MM.yyyy. Is this something that could be added to formatting options list for dates?
  • When the dd.MM.yyyy date is exported to Excel this date is not valid or does not pass across correctly. (due to period separators?)
  • Default time format in Germany is HH:mm:ss with leading zero for the hour value. Is this something that could be added to the formatting options list?

Comments (6)

photo
1

Hi Carsten,

I'm going to use this Idea for point 1, the dd.MM.yyyy enhancement request, and create a separate ticket for 2, and a separate idea for point 3. Please note that as a current workaround you can 'Format' > 'Edit' by clicking the arrow next to the header of your valid Date column and change 'Date Format' to 'Other' and type in "dd.MM.yyyy" under Custom Date Format.

I've gone ahead and logged this as an idea and opened an enhancement request under 9809 for potential future development and will keep this post updated with further information regarding this case.

Regards,

Mike

photo
1

Hi,

is there already an appearance in prospect

photo
1

Hi Carsten,

I haven't heard anything on this yet. I'm chasing for an update update regarding this.

Regards,

Mike

photo
1

Hi Carsten,


I had a quick look at this one and to have the formats natively available (part of the drop down list) we would have to do an enhancement.

In lieu of that, you can use the custom formatting option to achieve both the dd.MM.yyyy date format and the HH:mm:ss time format.

I also made a report with both of these formats and exported to XLSX and the date format came across fine (this was in the newest 7.4 build).

Maybe there is a bug in the older version here.


Thanks,

Lesley

photo
1

Hi,

yes that is what we made at the time. But I it is laborious to insert this in every date field. So at the Moment we use time and set "dd.MM.yyyy HH:mm:ss" . We need this timeformat and this Format don't work in Excel.

So we Need a solution for that.

So we Need:

as timestamp: "dd.MM.yyyy HH:mm:ss"

as Date: "dd.MM.yyyy"

as Time: "HH:mm:ss"

photo
1

Hi Carsten,

Thanks for the feedback. I've added this info from your most recent reply into our internal task. I'll let you know when I hear something else.

Regards,

Mike