Year 2003 being formatted as 2,003.00 1

[jfrost10]

Hey gang,

A coworker is having some weirdness with a formula.

he's got a string thats being output like this:

Year({his field with teh year value})

But it comes out as 2,003.00 instead of 2003

Any thoughts?

D'Arcy

 

[pgtek]

Hi
try this

CStr(CDate(1996, 11, 1), "yy MMM dd, dddd&quot

Returns "96 Nov 01, Monday".

hopr this helps

cheers

pgtek

 

[pgtek]

or
Year({his field with the year value})"0000"

 

[pgtek]

or
ToText (YEAR({your field}), "0000&quot

 

[pelajhia]

The basic problem stems from the fact that a year is just a number, like any other. The same thing would happen with month and day, fyi.

 

[synapsevampire]

Alternatively, you don't need a Year() formula at all.

Place the date field wherever you need it, right click it and select format field->Date/Time->Customize->Date/Time set to Date->Select Date->and set month and day to none.

-k