Date format is not appearing correct

[shahnawaz_khan]

Hi 

When I am "Cross Tab" to use vertical date in horizontal format then it converts date format "-" to "_"

Please check 2nd table, error highlighted in red color. 

From  below
Date	Country	Count
01-Jan-24	US	1
01-Jan-24	Africa	1
01-Jan-24	UK	1
01-Jan-24	Canada	1
01-Jan-24	France	1
02-Jan-24	US	1
02-Jan-24	Africa	1
02-Jan-24	UK	1
02-Jan-24	Canada	1
02-Jan-24	France	1
03-Jan-24	US	1
03-Jan-24	Africa	1
03-Jan-24	UK	1
03-Jan-24	Canada	1
03-Jan-24	France	1

To below
Country	01_Jan_2024	02_Jan_2024	03_Jan_2024	04_Jan_2024	05_Jan_2024	06_Jan_2024	01_Feb_2024	02_Feb_2024	03_Feb_2024
US	1	1	1	1	1	1	1	1	1
Africa	1	1	1	1	1	1	1	1	1
UK	1	1	1	1	1	1	1	1	1
Canada	1	1	1	1	1	1	1	1	1
France	1	1	1	1	1	1	1	1	1

Can we convert "_" to "-" again

[Raj · Accepted solution]

@shahnawaz_khan 
use dynamic rename
replace([_CurrentField_],"_","-")

this will solve the problem.
mark done if solved.

[binu_acs]

@shahnawaz_khan use the dynamic rename tool

[shahnawaz_khan]

thanks Raj, that helped allot