a local access 2013 22 rooms
in this video I will be talking to you about the date the function
social play-along follow the link below the video to the DOMA section website
and I Alexis 2013
the b16 and let's hope not what up
right now the last video
we were tempting and to create
a query folk rebooking details we're gonna
try and use a to the universe a query
and from not gonna commit to that
pop if we go to design view we can see what we do is we took table booking
details
and added all the information from that and where the next yr column
which was cost per night we're used to the lookup function to
return the across the room from Table rooms
and we were using every mighty to specify which were we won it
now bomber do in this video is
look at the difference the check in the rain check out I
and I want us to go to work out the duration of
a stay so if you look at this one
we've got checking that the $55 million the check out they have ninety
we want to return the mountain Mikes stay
well that would be tonight fifty not the sixteenth seventy
and eighty not the night the 19th to the check out a
so we would want his first record to return number for
I would also on the second record for time for we want
third to return 5 set researcher
so how do we do that quite simple really we use
the date the function so click in empty column
critical builder first we're gonna name this duration
Nicole on remember anything you cook for coal on
with the name if the filled and
free tap into day we go charging ahead you can see you got quite a few
different
I'm date functions you can use when we're interested in is
to today's date this by recommend you to go through them to see if you can make
some
sensitive for my are okay so
we've got take the function here CanoScan first to comment
to see you can bring up work to bring up the sort of extra information
we can see that we've got one to 3 arguments that we have to provide
and a couple of optional ones and his face don't worry too about the optional
ones
I never used them the August we have to provide at the interval
bait 1.82 date1 date2
are days people to find a difference in so it's going to be checkin and checkout
the interval is the kind of been too we want
so for example you can so the date the function that you want to return the
difference in
days I'm or are you might only be interested
in difference in months I have to do this to you I tend to
University use day's most the time
so maybe I'm not getting the most out my take two functions
but I think I can live with it okay so interval
I wanted to attend days and you refer to do that pits
are top professional the
double quotation mark that stays so you're passing
a string variable to the function
come up take one is check in date
Qamar check out like
to Plaza press OK
I see just bring it back up perversely to
so have a look at that duration code on date defrank send
info is TN quotation marks and check in they
check out they the check in then check out they refer to this check in to hear
that check out they
and if we run it you can see they returned for for the first time for for
the second
five for the first line which we can work ourselves but this gets bit more
tricky
when a really say but that's twenty nine nights
this one's more tricky sixty four months
okay so that's the date the function very useful functions to know about
I'm who -9 Exchange Act sorry yeah I was a day to function very fun to to know
about
have a play around with some others take function see what you can make of them
and and I sure hope to see nexidia offer save this