Forum Discussion
Possible to insert text in date column?
I have a date column that shows completed dates for projects, this is a data group to based off the actual date column so we can get the MMMM YYYY format. The blanks in this column represent projects...
Thank you for the reply. This helped as I changed my formula to:
Column = IF(ISBLANK([Finish Date]), "Active", FORMAT([Finish Date], "MMMM YYYY"))
This changes the column to Text, but now it is sorted alphabetically so there is more work to be done.
Hi,
to make it sort order change use index table and relate with your custom column.
Ex of index table
Index MonthYear
1 Active
2 Jan 2023
3 Feb 2023
4 Mar 2023
etc.
This dim table MonthYear column sort order should change by Index. I hope you know this concept.
Happy learning.