nik.be Posted December 12, 2005 Share Posted December 12, 2005 Hi all, I would like to create a serial nnumber for invoices purposes. I would like to have so that the first 3 digits are letter, then month and year, then a serial number. The problem that I am having is that I would like the date to appear as 1205 for december 2005, but all the time the year appears as 4 digits (122005). Any tips? Thanks Nik.Be Link to comment Share on other sites More sharing options...
Raybaudi Posted December 12, 2005 Share Posted December 12, 2005 Hi try this: Your3Chars & Month ( Get ( CurrentDate ) ) & Right ( Year (Get ( CurrentDate ) ) ; 2 ) & YourSerial Link to comment Share on other sites More sharing options...
nik.be Posted December 12, 2005 Author Share Posted December 12, 2005 Thanks raybaudi. Exactly wat I was looking for. Ciao Nik.Be Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6709 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now