Customer experience | Sales, Customer Insights,...

Add date to autonumber field

(0) Share

Report

Posted on by JeffGreenrc

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

All responses (4)

Answers (0)

Suggested answer

CRMJetty 3,508 on at

Like (0)

Report

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 84,325 Most Valuable Professional on at

Like (0)

Report

RE: Add date to autonumber field

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

Fubar 2,752 on at

Like (1)

Report

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 84,325 Most Valuable Professional on at

Like (1)

Report

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.