Re: calculating month of present date

Tech-Archive recommends: Speed Up your PC by fixing your registry


i format it as this

Format(month(date),"mm/dd/yyyy")

isn't it right?

Actually,my problem is this..

Currently the Start Date defaults to the first day of the current
month.
The request is to default the start date to the first day of the
quarter
(e.g. 01.01, 04.01,07.01,10.01... +year).

If the current month is between 1 and 3, default is 01.01.+current
year
If the current month is between 4 and 6, default is 04.01.+current
year

Please kindly guide.


--
anu_manu
------------------------------------------------------------------------
anu_manu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31510
View this thread: http://www.excelforum.com/showthread.php?threadid=516246

.

Relevant Pages

  • Re: Export data from VB6 to Label Printer
    ... I would request to guide me in preparing this label printer ... specially written drivers which "pretend to be" a real printer but instead of sending their output to a real printer they direct it to a specific format of file on your computer. ... Virtual printers usually create files in a very specific format, typically Adove pdf files or perhaps even bitmap or tiff or jpeg files. ...
    (comp.lang.basic.visual.misc)
  • Re: formatting ms access to ms excel report
    ... The command is working fine for the data in column A which is date field, ... Kindly guide about how to remove the error. ... you should open excel and use code to format the data ... Dim xl As Object ...
    (microsoft.public.excel.programming)
  • Size limits on IWMWriter::WriteSample ?
    ... building a profile from the stream information from the codec that mostly ... I'm using the "20kbps, 22Khz, Mono CBR" codec format. ... that is missing the end of the sample data. ...
    (microsoft.public.windowsmedia.sdk)
  • Re: Cant read PapaJohns PRX file
    ... I expected to see a big difference between the MM2 default profile which has ... reading I thought the DV-AVI format was going to knock my socks off. ... fact that they look similar in Media Player 10 because it displays in the ...
    (microsoft.public.windowsxp.moviemaker)
  • Re: help me in searching a good project
    ... > i has to make a project till march2006,i request u to please help me ... > and guide me on my project selection i am good at analog but weak in ... Lots of sensor work (shades of burger ...
    (sci.electronics.basics)