Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

how to apply custom format to calculated datetime field?

Posted on by 515

Hello,

I have datetime field 'DOB' which having datetime values, I want to create a new calculated field 'FormatedDOB' which will have copied value from DOB field with my custom datetime format. for e.g (2017 年 12 月 31日). How can I define my own custom format while defining calculated field? or is it possible to do by using some workflow?

Regards,

Ashish

*This post is locked for comments

  • Ashish Moradiya Profile Picture
    Ashish Moradiya 515 on at
    RE: how to apply custom format to calculated datetime field?

    Hi Alex,

    Text field is acceptable for me, I know how to create workflow but I couldn't understand what steps I will need to achieve it, and I also don't know about custom workflow activity, could provide more detail for this?

    thanks.

  • Suggested answer
    ashlega Profile Picture
    ashlega 34,475 on at
    RE: how to apply custom format to calculated datetime field?

    Hi Ashish,

     you cannot define custom format - Date Time format can be set in the CRM user personal settings.

     If you need custom format, you will need a text field and a custom workflow activity. Then you will be able to create a workflow that will use custom workflow activity to format the date, and, then, will put formatted value as a text to the new text field (can be a plugin as well). You won't be able to use a date picker for the text field of course.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans