The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.
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
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).
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 !!
Join us for a community conversation on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…
Join us for a community conversation on accelerating your motor simulation workflow with Simcenter Simlab. In this beginner-friendly session, we'll introduce the platform's automated model-building capabilities and show how easy it is to set up your first electric motor analysis. You'll see the basic steps of geometry…
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…
