change date type to be code type?

Dynamics 365 Business Central/NAV Developers Forum
#1

how to change date type to be code type

so I want to generate document number like this

Today = 06/16/10

so i want the Document No. → DOC 06/16/10

what should i do to be done like this?

thanks

#2

cant you change the date type in the table against the fields?

what do you mean by that you want your Doc no to be like DOC 06/16/10?

06/16/10 tis a date data type right!

sorry, i really cant understand your query.

#3

I want to import data from csv using dataport

so I want to generate document no automatically…

document no should be → DOC 06/16/10

DOC is default

06/16/10 is date of today

in the csv file, I don’t input any document no

#4

WWhat about:

Text := STRSUBSTNO(’%1 %2’,‘DOC’,TODAY);

Where TExt is a variable of data type Text.

#5

The FORMAT command will change date to text.

gsPostingDate := FORMAT(“Posting Date”);

#6

almost correct

but my document no field is code

not text

how to change to be code type

#7

You must be joking… NAV will convert Text to Code… Just use

“Document No.” := STRSUBSTNO(’%1 %2’,‘DOC’,TODAY);

#8

Okay… my mistake

the code is okay

thanks everyone :slight_smile: