Date Format

[gmacg]

Is there a way to format a Julian Date so that the year is displayed as 5 rather than 05? I am trying to format lot numbers that include the Julian date but only 1 digit is allowed for the year. I suppose I could take the easy way out and use the number 5 rather than the Julian Date, but then I'll have to change it manually in few months. If I could get rid of that 0 it would be smooth sailing until 2010. Any suggestions would be appreciated.

 

[SkipVought]

Hi,

Is this a REAL DATE, Formatted as Julian

or...

Is this just stored as a Numeric String (yyddd)?

Skip,
[sub]
[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart! [/sub]

 

[Blorf]

Hi.

Maybe right(year(date()), 1)?

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

http://mysite.verizon.net/res0n4sv/

 

[gmacg]

Thanks for the replies. You both really responded quickly! I fumbled around and figured it out for myself though. Here is what I came up with.

Format(Format(Date, "yy"), "0")

Again, thanks.

 

[PHV]

What about this for the julian date ?
1000*Format(Date,"yy")+Format(Date,"y")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244