How to make Date as a Display name in a Numbered list?
How do you make a Date as a Display Name in a Numbered list? I added a formula into my list properties with the format set as Date and the formula referencing the numbered list and the Date field. It pulled in the number properly to the Display Name. However, the new item created in the list is still a random number and not a date.
If I concatenate the date to a number, like : DAY(Date) + MONTH(Date) + YEAR(Date)
It adds up the numbers into one item. I need it in a number or a text for it to be a display name.
Re: How to make Date as a Display name in a Numbered list?
The display name will not let you select a date as an option in settings. It must be text. Is there a workaround like concatenating the date or something that would allow it to appear as text for the display name?
The Display Name can be a text or a List item, just not from the Time or Versions lists. So, you can create a "fake" time list that is flat with the correct code, and in the Display Name of your list, you can reference the Fake Time list.
Out of curiosity, why are you needing/wanting do this?