Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Date conversion

Discussion in 'Information Technology' started by caloy, Jul 28, 2006.

  1. caloy

    caloy
    Expand Collapse
    Guest

    =CDate(Format(Date()-28,"mm") & "/30/" & Format(Date()-28,"yyyy"))

    Can you please help me with this date function. I'm trying to write it so I
    will automatically get the "End of month" date. I still have to do this
    manually and change the date part.
    --
    Caloyski
     
  2. Loading...


  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    You can get the last day of this month like this:
    =DateSerial(Year(Date()), Month(Date())+1, 0)

    Access is able to figure out that day zero of next month is the last day of
    this month.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "caloy" <caloy@discussions.microsoft.com> wrote in message
    news:4BEFACEA-1920-41AD-A4A7-3F5E2E8CCAE2@microsoft.com...
    > =CDate(Format(Date()-28,"mm") & "/30/" & Format(Date()-28,"yyyy"))
    >
    > Can you please help me with this date function. I'm trying to write it so
    > I
    > will automatically get the "End of month" date. I still have to do this
    > manually and change the date part.
    > --
    > Caloyski
     
  4. Andrew Tapp

    Andrew Tapp
    Expand Collapse
    Guest

    To get the last day of the month try;
    DateAdd("d",-1,DateAdd("m",1,DateSerial(Year(Date()),Month(Date()),1)))

    Hope this helps.

    "caloy" wrote:

    > =CDate(Format(Date()-28,"mm") & "/30/" & Format(Date()-28,"yyyy"))
    >
    > Can you please help me with this date function. I'm trying to write it so I
    > will automatically get the "End of month" date. I still have to do this
    > manually and change the date part.
    > --
    > Caloyski
     
  5. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Expr1: DateAdd("m",1,Date())-Day(DateAdd("m",1,Date()))

    "caloy" wrote:

    > =CDate(Format(Date()-28,"mm") & "/30/" & Format(Date()-28,"yyyy"))
    >
    > Can you please help me with this date function. I'm trying to write it so I
    > will automatically get the "End of month" date. I still have to do this
    > manually and change the date part.
    > --
    > Caloyski
     

Share This Page