specific dates functions in unbound text box??

[andrew v via AccessMonster.com]

Is there a way to use a specific date in a function? for example, i only
want to know for every monday morning session how many seats has been
reserved and so on for one whole week? this number will change as the week
goes along. at the moment, this is how my form would like.

Week of??? date date date date date
Mon - AM #
Tue - PM #
Wed - AM #
Thu - PM #
Fri - AM #

any suggestions and help would be greatly appreciated. thanks in advance...

 

[Michel Walsh]

Hi,


Weekday( DateAndTimeValue ) returns the day of the week (vbSunday=1,
vbSaturday=7, as example); CDbl(TimeValue( DateAndTimeValue )) returns
the time part, as a decimal (portion) of a day: 0.5 = half a day = noon
while 0.75 = three quarters of a day = 18:00:00, or 6 PM. Using those two
expressions can help?


Vanderghast, Access MVP

 

[andrew v via AccessMonster.com]

i apologize, but may you give me some brief examples of how the function
works. this is the first time i've seen this function. looking at what
you've provided, looks like it will do the job...

thanks for the reply.

 

[Michel Walsh]

Hi,


Well... an example...?


? Weekday( Now )
5

? CDbl( TimeValue( Now) )
0.33333333333333


it would have been executed in the Debug Window (or Immediate Window), a
Thursday, 5, at 8 AM, one third or a day.


Hoping it may help,
Vanderghast, Access MVP