Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

Add date to autonumber field

(0) ShareShare
ReportReport
Posted on by

Hi,

I have a autonumber field. Its current format is "TK-0000001". I want to append date at the end of it. For e.g "TK-0000001-ddmmyy".

Please let me know how is this possible.

Thanks

  • Suggested answer
    CRMJetty Profile Picture
    CRMJetty 3,508 on at
    RE: Add date to autonumber field

    Hello,

    pls refer this article,

    https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/146170/auto-number-based-on-year/326230

    https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/146170/auto-number-based-on-year/326230

    I hope it helps,

    Thanks.

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: Add date to autonumber field

    LA thanks! Did not know that! That's why I like this community website!

  • Suggested answer
    Fubar Profile Picture
    Fubar 2,752 on at
    RE: Add date to autonumber field

    You can do it with the OOTB Autonumber, however the 1 issue is that the only value available is UTC.  In the make.powerapps.com interface go to a Text column and change it to Autonumber (or create a new autonumber field), in the Autonumber type dropdown select Custom, in the dropdown below the Format you can select to add Date after adding it you can then rearrange the yyyy-dd-MM elements e,g, ddMMyy is valid.

    This is an old page but has some examples of different formatting options docs.microsoft.com/.../create-auto-number-attributes

    Also, after the number is generated it is just a text value so you can also append after it has generated via plugin or workflow etc.

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: Add date to autonumber field

    Hello,

    I'm afraid you can't do that using OOB autonumber but you can do it using custom code - for example plugins.

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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans