Genesys Cloud - Main

I just ran an interactions report and was compiling the data and customizing the views to see date and time in separate columns, and consistently after 12 days the formatting of the date field changes. 

• the first interaction at the start of the month has a date stamp in this format 04/01/2026  00:12:00
• 3917 interactions later the date format is still the same 03/12/2026  23:30:00 and on the next day/interaction the format is like this 3/13/26 12:01 AM 
• this format continues until the end of the month 3/31/26 11:23 PM

Same thing in February

• the first interaction at the start of the month has a date stamp in this format 02/01/2026  00:12:00
• 4809 interactions later the date format is still the same 02/12/2026  23:43:00 and on the next day/interaction the format is like this 2/13/26 12:03 AM
• this format continues until the end of the month 2/28/26 11:55 PM

What is going on?

Hello, Conor.

Could you share the export settings that you have used? Are you using CSV or PDF?

I just ran an interactions report and was compiling the data and customizing the views to see date and time in separate columns, and consistently after 12 days the formatting of the date field changes. 

• the first interaction at the start of the month has a date stamp in this format 04/01/2026  00:12:00
• 3917 interactions later the date format is still the same 03/12/2026  23:30:00 and on the next day/interaction the format is like this 3/13/26 12:01 AM 
• this format continues until the end of the month 3/31/26 11:23 PM

Same thing in February

• the first interaction at the start of the month has a date stamp in this format 02/01/2026  00:12:00
• 4809 interactions later the date format is still the same 02/12/2026  23:43:00 and on the next day/interaction the format is like this 2/13/26 12:03 AM
• this format continues until the end of the month 2/28/26 11:55 PM

What is going on?

Hi Arthur,

The export settings that I am using are CSV as I wanted to open the data directly in Excel.

Hello, Conor.

Could you share the export settings that you have used? Are you using CSV or PDF?

I just ran an interactions report and was compiling the data and customizing the views to see date and time in separate columns, and consistently after 12 days the formatting of the date field changes. 

• the first interaction at the start of the month has a date stamp in this format 04/01/2026  00:12:00
• 3917 interactions later the date format is still the same 03/12/2026  23:30:00 and on the next day/interaction the format is like this 3/13/26 12:01 AM 
• this format continues until the end of the month 3/31/26 11:23 PM

Same thing in February

• the first interaction at the start of the month has a date stamp in this format 02/01/2026  00:12:00
• 4809 interactions later the date format is still the same 02/12/2026  23:43:00 and on the next day/interaction the format is like this 2/13/26 12:03 AM
• this format continues until the end of the month 2/28/26 11:55 PM

What is going on?

Hi Conor

I think this might be an excel issue and how it interprets the data.  I tested on my side and noticed the same.  When I did a export using pdf format, all the dates include AM/PM 

You might need to play around for the format and see if you can change this in csv file itself.

Regards

Hi Arthur,

The export settings that I am using are CSV as I wanted to open the data directly in Excel.

Hello, Conor.

Could you share the export settings that you have used? Are you using CSV or PDF?

I just ran an interactions report and was compiling the data and customizing the views to see date and time in separate columns, and consistently after 12 days the formatting of the date field changes. 

• the first interaction at the start of the month has a date stamp in this format 04/01/2026  00:12:00
• 3917 interactions later the date format is still the same 03/12/2026  23:30:00 and on the next day/interaction the format is like this 3/13/26 12:01 AM 
• this format continues until the end of the month 3/31/26 11:23 PM

Same thing in February

• the first interaction at the start of the month has a date stamp in this format 02/01/2026  00:12:00
• 4809 interactions later the date format is still the same 02/12/2026  23:43:00 and on the next day/interaction the format is like this 2/13/26 12:03 AM
• this format continues until the end of the month 2/28/26 11:55 PM

What is going on?

I just ran an interactions report and was compiling the data and customizing the views to see date and time in separate columns, and consistently after 12 days the formatting of the date field changes. 

• the first interaction at the start of the month has a date stamp in this format 04/01/2026  00:12:00
• 3917 interactions later the date format is still the same 03/12/2026  23:30:00 and on the next day/interaction the format is like this 3/13/26 12:01 AM 
• this format continues until the end of the month 3/31/26 11:23 PM

Same thing in February

• the first interaction at the start of the month has a date stamp in this format 02/01/2026  00:12:00
• 4809 interactions later the date format is still the same 02/12/2026  23:43:00 and on the next day/interaction the format is like this 2/13/26 12:03 AM
• this format continues until the end of the month 2/28/26 11:55 PM

What is going on?

Hi Conor,

We had this recently. It's down to the Language setting on the export. Time zone / your org location doesn't matter. Default is English (US) which also sets the csv date format in US MMDDYY date format. Change it to English (GB) and it should then show in DDMMYYYY format.

I just ran an interactions report and was compiling the data and customizing the views to see date and time in separate columns, and consistently after 12 days the formatting of the date field changes. 

• the first interaction at the start of the month has a date stamp in this format 04/01/2026  00:12:00
• 3917 interactions later the date format is still the same 03/12/2026  23:30:00 and on the next day/interaction the format is like this 3/13/26 12:01 AM 
• this format continues until the end of the month 3/31/26 11:23 PM

Same thing in February

• the first interaction at the start of the month has a date stamp in this format 02/01/2026  00:12:00
• 4809 interactions later the date format is still the same 02/12/2026  23:43:00 and on the next day/interaction the format is like this 2/13/26 12:03 AM
• this format continues until the end of the month 2/28/26 11:55 PM

What is going on?