Convert numeric date to text
I have a report that I've pulled from a SQL database that creates a column with the numeric date and time something was created.
I've split that column so that I get only Year and Month.
Is there any way to convert the Month to text? In other words, "July" instead of "7".
Thanks!
Find more posts tagged with
Altair EmployeeIn addition to the previous response, you can also create a new lookup column on the field you are trying to modify and set the appropriate values:
or create a spreadsheet with values and then join them to that spreadsheet.
In addition to the previous response, you can also create a new lookup column on the field you are trying to modify and set the appropriate values:
or create a spreadsheet with values and then join them to that spreadsheet.
Yes! I found the Lookup Column and was able to convert, but I appreciate the SQL.
Thanks, Chris!
Hi Michele,
I think there are many different ways to do that. But I don't know any quick one
You could create a valid date from month-column, for example 7 = 1.7.2023 and then change column format to month full name.
Or you could create a excel table with the numbers and names of the months and then join it with your data.
Or you could just create a new formula column with expression:
If ([CreatedDateTimeMonth] = 1; "January";
If ([CreatedDateTimeMonth] = 2; "February";
If ([CreatedDateTimeMonth] = 3; "March";
If ([CreatedDateTimeMonth] = 4; "April";
If ([CreatedDateTimeMonth] = 5; "May";
If ([CreatedDateTimeMonth] = 6; "June";
If ([CreatedDateTimeMonth] = 7; "July";
If ([CreatedDateTimeMonth] = 8; "August";
If ([CreatedDateTimeMonth] = 9; "September";
If ([CreatedDateTimeMonth] = 10; "October";
If ([CreatedDateTimeMonth] = 11; "November";
If ([CreatedDateTimeMonth] = 12; "December";""))))))))))))
-Lasse