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

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?
 
A

Andrew

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top