Hugo,

Now I understood where your question came from..Please check your other post.

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Try

Msgbox "Q" &format(Date,"q-yy")

Replace Date() with your date variable..

If this post helps click Yes
---------------
Jacob Skaria


"Hugo" wrote:

Hi,

I am writing writing a subroutine which works with a series of quarterly
dates (e.g. "Q3-08, Q4-08, Q1-09, Q2-09,..." in a single row. I had wanted
to use CDate in my routine, but I can't get it to work with the date format I
am using. Any thoughts?
--
Hugo