Year(Date) Function

[ltamisin]

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

 

[Adrienne]

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

 

[ltamisin]

Hey Adrienne thanks

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