Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Suggested answer

Add date to autonumber field

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,321 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,750 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,321 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans