[AccessD] Format Year in a number

Try

EVALNO: "EVAL-" & [DISCIPLINENO] & "-" & FORMAT(NOW(), "YY") & "-" &
Format([EVTaskNum],"000"

Patti

******************************************************************
*Patricia O'Connor
*Associate Computer Programmer Analyst
*OTDA - BDMA
*(W) mailto:Patricia.O'Connor at dfa.state.ny.us
*(w) mailto:aa1160 at dfa.state.ny.us
******************************************************************
 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Hollis,Virginia
> Sent: Monday, August 16, 2004 11:15 AM
> To: 'accessd at databaseadvisors.com'
> Subject: [AccessD] Format Year in a number
> 
> Yes, the current year, but I need the year formatted with 
> just 2 digits. I tried this & get 2004, I just need 04.
> **********************
> You mean the current year? 
>  
> EvalNo: "EVAL-" & [DisciplineNo] & "-" & Year(Now)) & "-" &
> Format([EVTaskNum],"000")
>  
> Susan H. 
>  
> I need to assign a number for a document that contains the 
> discipline number, the year, and a new task number. I can't 
> seem to get the year part to work - how do I have it add the 
> year to a number (and it must change every year too)? The 
> year would come after the discipline so the number would be: 
> EVAL-123-04-001.
>  
>  
>  
> EvalNo: "EVAL " & [DisciplineNo] & "-" & Format([EVTaskNum],"000")
>  
>  
>  
> Virginia
>  
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> <http://databaseadvisors.com/mailman/listinfo/accessd>
> http://databaseadvisors.com/mailman/listinfo/accessd
> <http://databaseadvisors.com/mailman/listinfo/accessd>
> Website: http://www.databaseadvisors.com 
> <http://www.databaseadvisors.com> 
>  
> 
>  
> 
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>