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 have a number of different date types in a text file that I am building a model for. The ones that are formatted YYYYMMDD I have been fine with getting those to format the way I want. The one I am having issues with is when it is formatted YYYYMM.
You didn't mention which version of Monarch you are using, but this should work for most. Bring in the date field with the YYYYMM as a character type. You can then create a new formula field with the data type of "Date/Time". You can then use some string concatenation and the character to date conversion function. For example, if my character date field name is "date2", with the value of "201801" for January 2018, I can use this formula:
ctod(date2+"01","y/m/d")
which converts this to 01/01/2018.
If you want to use the last day of the month, modify the formula to:
End_Of_Current_Month(ctod(date2+"01","y/m/d"))
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…
