i'm ok taxes 2013 tutorials
any city wrong to show you how to use it date serial function
take on a fly along follow the link below the video to Damasus the website
in Dallas Texas 2013
TV 54 an open up
now why am i showing you how to use the
day Syria function
well con again into the home stretch of creating the
database and database work rating is for hotels acute record bookings
as we've been creating a database I'm you may notice the love
the information is in the past
and the next thing I want to do is create the show job which is
basically visual representation of the data in a database
a.m. and rather than may have to go and im for Lotus
new data so as I can keep up to date while Max unit is changed bassist
bookings here and booking details here so
it be exactly the same except the month for the update to the current month's
yeah I am Sha Sha Sha Sha
for the update the years to the current year's well a.m.
so too you can run the update query and then
it updated information so we gonna need a serial to do that in a nutshell
so go to create go to create designs were gonna be using an update query to
do this saying
at table bookings so if I at a
checkin day run that you can see this till the check intakes
I want to do that as well update I wanna keep actually the day
but I want the months in the year to be update to the current months in year
so you can ease take serious a first we're gonna create separate field
duster so click in top row of the
Jason vacant room click on builder
stand this is foolish check in new
semicolon defeat
me the start date serial function comma
you can see today sir function takes a year months and a day
and and returns a serial
they say basically you per year month a date in your date back is simply that's
about to end
a.m. 2013 Ossory
social life okay and run it
I get 5th March 2013 obviously issuer
American those two will be reversed actually I'm
and his quest simple as that the key point is cuz you're into in the year the
month to the day you can break a date down and you can manipulate which is
exactly what I'm going to do here
so messed up with the year well I want
to in I am the year that we're currently in
it's a very simple seven-year as a year function open/close brackets and within
amputate
to its gonna do is gonna take the current day power which is
the 29th July 2013 as gonna take the year
valuation that day size unit 8 2013 SOC the years canary 2013
now you get to the month same idea months
take so
a.m. it's gonna take a day or two said 29 to July 2013
and generate a month which is to life which is seven
so it's cancelled the year misconstrue the martyrs me 2037
and I want to keep the day the same solamente
to use on a take that day from the check in date so
on this eight-day and then
exciting to do is it table booking details
top check in date stress okay
saffir run back it's taken 15 from splitting hairs taken 26 is to do here
take a 20 things to do here nazis update everything
Skepta days by its made all the months and years to current month
yes he is still the same but the month because she's been updated
selected designed you never gonna do the same with
check out a we're gonna be a bit cheeky because we're gonna kick in check in New
okay control seemed to copy and paste
here
snowing United okay
I just run that never done the same thing with the checkup tire is updated
the months in a year vaccine made it consistently does she s 26
I sit us know only one has a tell you are gonna take the check out taking on
Adam
stone at 12 so quite simple
the back here for months
just after the second break or just before the
comma plus one not like I can run that
okay set up to it everything to August
okay to back to the design view and we change it's an update query
and we're gonna take catch a formula for checkin new
we're gonna drop in uptake to and we're gonna take
the one gonna take the formula for check out new
so I can
section future in here she moved to
over Mitt Romney shows am I gonna
highlight these two and pest control X
get rid quickly about Cleary's
you get datasheet view just
a displays data doesn't actually run the query
effect as I'm in Africa run we make the actual obtain after-the-fact today she
view
actually shows up to date information folks let's save this and delete query
booking tito's
a crew booking details
update day update a
smooth worst think wherever whether but after that without
I am gonna do the same thing for
bookings very simple great design table working two sons babies are actually two
into one day
just run that kept looking day a.m.
and co-op say good uptake to click on
builder with an update to take serial
same concept to the year we want day
months we're gonna
just take the current month so we won
also day and then the
day you on today and we were on
table bookings
dots King Day
an awful lot of one more bracket so click day she view festival say
still says March my and all that and run it not affect the issue
update everything 27 I'll save this one call it
Creary updating
cleary booking is
update takes so
its Sebastian Manokwari brilliant so we learned a couple things they
learn about they series we've learned how not to name queries
I am and yet history we actually learn also the year month and day function a
go
police things in one video alright cool
pretty okay so see next video have a good