1
00:00:00,900 --> 00:00:03,629
i'm ok taxes 2013 tutorials

2
00:00:03,629 --> 00:00:07,869
any city wrong to show you how to use it date serial function

3
00:00:07,870 --> 00:00:11,809
take on a fly along follow the link below the video to Damasus the website

4
00:00:11,808 --> 00:00:13,709
in Dallas Texas 2013

5
00:00:13,710 --> 00:00:20,240
TV 54 an open up

6
00:00:20,239 --> 00:00:23,909
now why am i showing you how to use the

7
00:00:23,910 --> 00:00:27,839
day Syria function

8
00:00:27,839 --> 00:00:31,980
well con again into the home stretch of creating the

9
00:00:31,980 --> 00:00:37,070
database and database work rating is for hotels acute record bookings

10
00:00:37,070 --> 00:00:42,119
as we've been creating a database I'm you may notice the love

11
00:00:42,119 --> 00:00:45,839
the information is in the past

12
00:00:45,840 --> 00:00:49,280
and the next thing I want to do is create the show job which is

13
00:00:49,280 --> 00:00:52,609
basically visual representation of the data in a database

14
00:00:52,609 --> 00:00:56,488
a.m. and rather than may have to go and im for Lotus

15
00:00:56,488 --> 00:01:02,299
new data so as I can keep up to date while Max unit is changed bassist

16
00:01:02,299 --> 00:01:05,408
bookings here and booking details here so

17
00:01:05,409 --> 00:01:09,340
it be exactly the same except the month for the update to the current month's

18
00:01:09,340 --> 00:01:13,909
yeah I am Sha Sha Sha Sha

19
00:01:13,909 --> 00:01:17,420
for the update the years to the current year's well a.m.

20
00:01:17,420 --> 00:01:21,359
so too you can run the update query and then

21
00:01:21,359 --> 00:01:25,239
it updated information so we gonna need a serial to do that in a nutshell

22
00:01:25,239 --> 00:01:31,339
so go to create go to create designs were gonna be using an update query to

23
00:01:31,340 --> 00:01:32,280
do this saying

24
00:01:32,280 --> 00:01:35,519
at table bookings so if I at a

25
00:01:35,519 --> 00:01:39,530
checkin day run that you can see this till the check intakes

26
00:01:39,530 --> 00:01:43,439
I want to do that as well update I wanna keep actually the day

27
00:01:43,438 --> 00:01:48,758
but I want the months in the year to be update to the current months in year

28
00:01:48,759 --> 00:01:53,129
so you can ease take serious a first we're gonna create separate field

29
00:01:53,129 --> 00:01:57,489
duster so click in top row of the

30
00:01:57,489 --> 00:02:00,500
Jason vacant room click on builder

31
00:02:00,500 --> 00:02:03,549
stand this is foolish check in new

32
00:02:03,549 --> 00:02:06,710
semicolon defeat

33
00:02:06,709 --> 00:02:11,560
me the start date serial function comma

34
00:02:11,560 --> 00:02:15,789
you can see today sir function takes a year months and a day

35
00:02:15,789 --> 00:02:19,329
and and returns a serial

36
00:02:19,330 --> 00:02:24,370
they say basically you per year month a date in your date back is simply that's

37
00:02:24,370 --> 00:02:25,128
about to end

38
00:02:25,128 --> 00:02:28,399
a.m. 2013 Ossory

39
00:02:28,400 --> 00:02:32,459
social life okay and run it

40
00:02:32,459 --> 00:02:37,890
I get 5th March 2013 obviously issuer

41
00:02:37,889 --> 00:02:42,549
American those two will be reversed actually I'm

42
00:02:42,550 --> 00:02:47,280
and his quest simple as that the key point is cuz you're into in the year the

43
00:02:47,280 --> 00:02:50,680
month to the day you can break a date down and you can manipulate which is

44
00:02:50,680 --> 00:02:52,050
exactly what I'm going to do here

45
00:02:52,050 --> 00:02:55,840
so messed up with the year well I want

46
00:02:55,840 --> 00:02:59,009
to in I am the year that we're currently in

47
00:02:59,009 --> 00:03:04,039
it's a very simple seven-year as a year function open/close brackets and within

48
00:03:04,039 --> 00:03:05,030
amputate

49
00:03:05,030 --> 00:03:09,110
to its gonna do is gonna take the current day power which is

50
00:03:09,110 --> 00:03:12,500
the 29th July 2013 as gonna take the year

51
00:03:12,500 --> 00:03:17,419
valuation that day size unit 8 2013 SOC the years canary 2013

52
00:03:17,419 --> 00:03:21,500
now you get to the month same idea months

53
00:03:21,500 --> 00:03:24,519
take so

54
00:03:24,519 --> 00:03:28,539
a.m. it's gonna take a day or two said 29 to July 2013

55
00:03:28,539 --> 00:03:31,780
and generate a month which is to life which is seven

56
00:03:31,780 --> 00:03:36,120
so it's cancelled the year misconstrue the martyrs me 2037

57
00:03:36,120 --> 00:03:39,459
and I want to keep the day the same solamente

58
00:03:39,459 --> 00:03:42,950
to use on a take that day from the check in date so

59
00:03:42,949 --> 00:03:46,289
on this eight-day and then

60
00:03:46,289 --> 00:03:50,329
exciting to do is it table booking details

61
00:03:50,330 --> 00:03:54,430
top check in date stress okay

62
00:03:54,430 --> 00:04:00,400
saffir run back it's taken 15 from splitting hairs taken 26 is to do here

63
00:04:00,400 --> 00:04:04,789
take a 20 things to do here nazis update everything

64
00:04:04,789 --> 00:04:08,650
Skepta days by its made all the months and years to current month

65
00:04:08,650 --> 00:04:11,860
yes he is still the same but the month because she's been updated

66
00:04:11,860 --> 00:04:15,049
selected designed you never gonna do the same with

67
00:04:15,049 --> 00:04:19,350
check out a we're gonna be a bit cheeky because we're gonna kick in check in New

68
00:04:19,350 --> 00:04:24,350
okay control seemed to copy and paste

69
00:04:24,350 --> 00:04:31,350
here

70
00:04:37,389 --> 00:04:40,399
snowing United okay

71
00:04:40,399 --> 00:04:46,689
I just run that never done the same thing with the checkup tire is updated

72
00:04:46,689 --> 00:04:51,930
the months in a year vaccine made it consistently does she s 26

73
00:04:51,930 --> 00:04:57,240
I sit us know only one has a tell you are gonna take the check out taking on

74
00:04:57,240 --> 00:04:57,750
Adam

75
00:04:57,750 --> 00:05:01,019
stone at 12 so quite simple

76
00:05:01,019 --> 00:05:05,000
the back here for months

77
00:05:05,000 --> 00:05:08,019
just after the second break or just before the

78
00:05:08,019 --> 00:05:12,449
comma plus one not like I can run that

79
00:05:12,449 --> 00:05:16,810
okay set up to it everything to August

80
00:05:16,810 --> 00:05:20,759
okay to back to the design view and we change it's an update query

81
00:05:20,759 --> 00:05:25,730
and we're gonna take catch a formula for checkin new

82
00:05:25,730 --> 00:05:29,980
we're gonna drop in uptake to and we're gonna take

83
00:05:29,980 --> 00:05:35,780
the one gonna take the formula for check out new

84
00:05:35,779 --> 00:05:40,029
so I can

85
00:05:40,029 --> 00:05:44,899
section future in here she moved to

86
00:05:44,899 --> 00:05:47,989
over Mitt Romney shows am I gonna

87
00:05:47,990 --> 00:05:51,129
highlight these two and pest control X

88
00:05:51,129 --> 00:05:54,350
get rid quickly about Cleary's

89
00:05:54,350 --> 00:05:57,790
you get datasheet view just

90
00:05:57,790 --> 00:06:01,970
a displays data doesn't actually run the query

91
00:06:01,970 --> 00:06:06,950
effect as I'm in Africa run we make the actual obtain after-the-fact today she

92
00:06:06,949 --> 00:06:07,409
view

93
00:06:07,410 --> 00:06:12,550
actually shows up to date information folks let's save this and delete query

94
00:06:12,550 --> 00:06:16,490
booking tito's

95
00:06:16,490 --> 00:06:19,590
a crew booking details

96
00:06:19,589 --> 00:06:23,209
update day update a

97
00:06:23,209 --> 00:06:26,819
smooth worst think wherever whether but after that without

98
00:06:26,819 --> 00:06:30,189
I am gonna do the same thing for

99
00:06:30,189 --> 00:06:35,430
bookings very simple great design table working two sons babies are actually two

100
00:06:35,430 --> 00:06:36,540
into one day

101
00:06:36,540 --> 00:06:40,680
just run that kept looking day a.m.

102
00:06:40,680 --> 00:06:44,269
and co-op say good uptake to click on

103
00:06:44,269 --> 00:06:47,870
builder with an update to take serial

104
00:06:47,870 --> 00:06:53,819
same concept to the year we want day

105
00:06:53,819 --> 00:06:56,879
months we're gonna

106
00:06:56,879 --> 00:07:00,370
just take the current month so we won

107
00:07:00,370 --> 00:07:04,860
also day and then the

108
00:07:04,860 --> 00:07:08,710
day you on today and we were on

109
00:07:08,709 --> 00:07:11,879
table bookings

110
00:07:11,879 --> 00:07:15,300
dots King Day

111
00:07:15,300 --> 00:07:21,230
an awful lot of one more bracket so click day she view festival say

112
00:07:21,230 --> 00:07:26,560
still says March my and all that and run it not affect the issue

113
00:07:26,560 --> 00:07:29,949
update everything 27 I'll save this one call it

114
00:07:29,949 --> 00:07:33,329
Creary updating

115
00:07:33,329 --> 00:07:38,209
cleary booking is

116
00:07:38,209 --> 00:07:41,239
update takes so

117
00:07:41,240 --> 00:07:46,810
its Sebastian Manokwari brilliant so we learned a couple things they

118
00:07:46,810 --> 00:07:50,120
learn about they series we've learned how not to name queries

119
00:07:50,120 --> 00:07:55,530
I am and yet history we actually learn also the year month and day function a

120
00:07:55,529 --> 00:07:55,879
go

121
00:07:55,879 --> 00:07:59,399
police things in one video alright cool

122
00:07:59,399 --> 00:08:02,250
pretty okay so see next video have a good