«

Hi

Im working on a Year(Date) function right now, the output of that function
is this "2005", my question is how can i change the format into this "05"

Function: Year(Date)
Output: 2005
Needed Output: 05

Thanks

Gazing into my crystal ball I observed "ltamisin" <>
writing in news::

> Hi
>
> Im working on a Year(Date) function right now, the output of that
> function is this "2005", my question is how can i change the format
> into this "05"
>
> Function: Year(Date)
> Output: 2005
> Needed Output: 05
>


Function Year(Date)
Year = Right(Datepart("yyyy",Date),2)
End Function

--
Adrienne Boswell
http://www.cavalcade-of-coding.info
Please respond to the group so others can share

Hey Adrienne thanks

"Adrienne" <> wrote in message
news:Xns9667CC894EACarbpenyahoocom@207.115.63.158. ..
> Gazing into my crystal ball I observed "ltamisin" <>
> writing in news::
>
> > Hi
> >
> > Im working on a Year(Date) function right now, the output of that
> > function is this "2005", my question is how can i change the format
> > into this "05"
> >
> > Function: Year(Date)
> > Output: 2005
> > Needed Output: 05
> >
>
>
> Function Year(Date)
> Year = Right(Datepart("yyyy",Date),2)
> End Function
>
> --
> Adrienne Boswell
> http://www.cavalcade-of-coding.info
> Please respond to the group so others can share