Quarterly date format issues
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
|