Digit re-combination

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I am new here, please be patient
In a query I have a field called MEMBERSHIPDATE with a format DD/MM/YYYY,
from it I want to generate, in anotyher column, a number with the following
format DDMMY. Please see examples for clarifing:
1/12/2005 I want to obtain 01125 (for the year I use the last digit)
8/2/2004 Iwant to obtain 08024 (for the year I use the last digit)
Please let me know what expresion can retreive such a number. Thanks
 
After you post once, please be patient and give us time to respond!!!

See your previous post.
 
viddom said:
Hi, I am new here, please be patient
In a query I have a field called MEMBERSHIPDATE with a format DD/MM/YYYY,
from it I want to generate, in anotyher column, a number with the following
format DDMMY. Please see examples for clarifing:
1/12/2005 I want to obtain 01125 (for the year I use the last digit)
8/2/2004 Iwant to obtain 08024 (for the year I use the last digit)
Please let me know what expresion can retreive such a number. Thanks
Click to expand...

Answered in a previous post with the same question.
 
Back
Top