Date conversion

=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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9817-date-conversion.html
will automatically get the "End of month" date. I still have to do this
manually and change the date part.
--
Caloyski

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

You can get the last day of this month like this:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9817
=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" 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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9817
> --
> Caloyski

To get the last day of the month try;
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9817
DateAdd("d",-1,DateAdd("m",1,DateSerial(Year(Date()),Month(Date()),1)))

Hope this helps.

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9817
"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

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

"caloy" wrote:

> =CDate(Format(Date()-28,"mm") & "/30/" & Format(Date()-28,"yyyy"))
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9817
>
> Can you please help me with this date function. I'm trying to write it so I
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9817
> will automatically get the "End of month" date. I still have to do this
> manually and change the date part.
> --
> Caloyski