Format dates

[TheWes]

Hi guys,

How do I obtain the month and year this table.
The month and year function does not work.
I also tried reformatting the column and then retrying the number.
Thank you.

Iso Year Result	Client Nr	Function Descr	Occupational Hazard Group Descr	Occupational Sales Group Descr	Month of Create Date Assignment	Start Date Assignment
2023	267379	1 Nov 2022	11/01/2022 00:00
2023	267379	1 Nov 2022	11/01/2022 00:00
2023	267379	1 Feb 2023	2/27/2023 12:00:00 AM
2023	267379	1 Feb 2023	2/27/2023 12:00:00 AM
2023	267379	1 Feb 2023	2/27/2023 12:00:00 AM
2023	267379	1 Feb 2023	2/27/2023 12:00:00 AM

 

[etaf]

i suspect those are NOT real dates BUT text
Are you importing this information from somewhere ????

are you still using Excel; 2016 ???

then a TEXT extract perhaps with Datevalue may help

 

[TheWes]

Solved.
I simply did not format columns via year function as numbers.

 

[etaf]

glad its solved