convert date to a Text format

[badmullah]

i have a date field and i want to have another column next to it that would have the text format in YYMMDD format

3-oct-22 becomes 221003

Thanks

[JohnTopley]

so Custom format as YYMMDD.

[badmullah]

still consider it as a date and once you do pivot table it groups them base on months.

i dont want that
i want to group them based on days and thats why i m trying to show it as this and change the attribute of the cell

[avk]

try

Please Login or Register  to view this content.