Writing Expressions that use DatePart (y) and user info for contr

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

I am attempting to write an expression in a field that uses Datepart (y) and
2 user numbers and 3 user letters and 2 more user numbers as part of a Form
identification field. I can't seem to get the expression Right. An example of
how I would like it to look is as follows: 36500AJB00, the 365 is day of
year, 00 is operater input, the three letters are operater input and the 2
zeros that follow are operater input. Any suggestions?
 
I am trying to convert the DatePart from a user input date (from the form
they are filling out), and have that as the first three numbers in the series
of the rest of the user defined (7 more digits or letters required as defined
by ##LLL##) ID. The whole expression once put together will be a unique ID.

Example: DatePart(y),[ReportDate],&"##LLL##" so what will come up in the
Cell Report Number will be 096##LLL## or once filled in by the user could be
09699AJB37

Im not sure how to do this.
 
Back
Top