How to add * in a date field-before and after the date?


Updated by Altair Forum User
I would like to be able to take a date field and add an * before and after it and I need some assistance. I would like the date to display like: *02-28-18*.
I have tried everything I can think of short of purchasing the Kutools add on for excel.
Thank you in advance,
Brian
Sort by:
1 - 2 of
21


Updated by Altair Forum User
You need to create a new calcualted/formula field with the data type of "character". You can then use the following formula:
"*"+dtoc([Original Date])+"*"
where [Original Date] should be substituted with the correct field name. Since you will be outputing a character data type, you need to convert the date field from a date data type to a character data type (dtoc).
Chris, That worked ! Thanks very much !!
You need to create a new calcualted/formula field with the data type of "character". You can then use the following formula:
"*"+dtoc([Original Date])+"*"
where [Original Date] should be substituted with the correct field name. Since you will be outputing a character data type, you need to convert the date field from a date data type to a character data type (dtoc).