yyyy/mm/dd to yyyy/mm

I am new to Creatio.

I would like to create a Date field and change it from yyyy/mm/dd to yyyy/mm. However, I have looked and cannot find a way to do this.

Is there a better way to do this?

I am thinking that 2023/11/14 should be 2023/11.

 

File attachments
Like 0

Like

1 comments
Best reply

I have done this without the "/" by creating a new string field called "Period" and having a business process which updates that field. The formula was (based on my date field)

 

[#read opps line.First item of resulting collection.Opportunity Line Date#].ToString("yyyyMM")

 

You could try by adding the "/" after the yyyy.

I have done this without the "/" by creating a new string field called "Period" and having a business process which updates that field. The formula was (based on my date field)

 

[#read opps line.First item of resulting collection.Opportunity Line Date#].ToString("yyyyMM")

 

You could try by adding the "/" after the yyyy.

Show all comments