Access 2010 Web Database Date() Function

[joycekuo]

Hi Guys

I am working onan Access 2010 web database and would like to know if there is aDate() function
or similar, that I can use to default the start date on my form to bethe first day of last month, and
the end date to be the last day of lastmonth

Take today for example, the form default value for start date will be 1 May 2014 and end date 31
May 2014. Thank you!

Opps~ Apologies. This is suppose to be for the "Access" in general category. Will I be able to


move this, or if someone could will be great.

[ranman256]

Yes...it is exactly that: Date()

i have home built functions to get these start / end dates
1st of the month: StartOMonth() =(mm & "/1/" & yyyy)
end o month = dateadd("d",-1,dateadd("m",1,StartOMonth())

[joycekuo]

Yes...it is exactly that: Date()

i have home built functions to get these start / end dates
1st of the month: StartOMonth() =(mm & "/1/" & yyyy)
end o month = dateadd("d",-1,dateadd("m",1,StartOMonth())

Thank you Ranman256 for your reply.

I am still a bit lost, as I do not think the Web Access recognize the Dateadd function, and
I cannot quite get the Start of Month function to work either. Should I be building this at
a differnt place or calling it separately..??

[June7]

Start of the month for the current date:

Month(Date()) & "/1/" & Year(Date())

Try that in the DefaultValue property.

[joycekuo]

Start of the month for the current date:

Month(Date()) & "/1/" & Year(Date())

Try that in the DefaultValue property.

Thanks June7.
That kinda work, so it has given me 06/01/2014 (given 6 is the current month?).

I have tried to play with the time format to make it dd/mm/yyyy and also to pass
the previous month instead, but ="1/" & Month(Date())-1 & Year(Date()) doesn't
seems to be a web compatible format. =P

Any ideas? And do you know how to add an end of month date?

[joycekuo]

YES!!! I've worked out the start date part in default value (no equal sign):
"1/" & Month(Date())-1 & "/" & Year(Date())

Just need the end of month date now, having it vary from 30th and 31st
depending on previous month.

[June7]

Beware of dates in non-Access standard format. Review: http://allenbrowne.com/ser-36.html

If DateAdd() won't work, not sure how you can accomplish the end month calc.

[joycekuo]

Beware of dates in non-Access standard format. Review: http://allenbrowne.com/ser-36.html

If DateAdd() won't work, not sure how you can accomplish the end month calc.

Eeeeek~~ The database is in UK time format, so I am hoping the start date would work.
Have tested a simple DateAdd function and it does work for Web DBs. Just not with the
function above.

I will have another crack at this...

[joycekuo]

FirstDay of Previous Month = DateSerial(Year(DateAdd("m", -1, Now)), Month(DateAdd("m", -1, Now)), 1)
LastDay of Previous Month = DateAdd("d", -1, DateSerial(Year(Now), Month(Now), 1))

Is works prefectly! Cheers All for your help.