1 00:00:01,569 --> 00:00:04,019 a local access 2013 22 rooms 2 00:00:04,019 --> 00:00:07,330 in this video I will be talking to you about the date the function 3 00:00:07,330 --> 00:00:11,009 social play-along follow the link below the video to the DOMA section website 4 00:00:11,009 --> 00:00:12,820 and I Alexis 2013 5 00:00:12,820 --> 00:00:16,359 the b16 and let's hope not what up 6 00:00:16,359 --> 00:00:20,400 right now the last video 7 00:00:20,399 --> 00:00:25,669 we were tempting and to create 8 00:00:25,670 --> 00:00:29,220 a query folk rebooking details we're gonna 9 00:00:29,219 --> 00:00:32,839 try and use a to the universe a query 10 00:00:32,840 --> 00:00:36,559 and from not gonna commit to that 11 00:00:36,558 --> 00:00:41,189 pop if we go to design view we can see what we do is we took table booking 12 00:00:41,189 --> 00:00:42,140 details 13 00:00:42,140 --> 00:00:45,739 and added all the information from that and where the next yr column 14 00:00:45,738 --> 00:00:50,238 which was cost per night we're used to the lookup function to 15 00:00:50,238 --> 00:00:54,339 return the across the room from Table rooms 16 00:00:54,340 --> 00:00:57,989 and we were using every mighty to specify which were we won it 17 00:00:57,988 --> 00:01:01,409 now bomber do in this video is 18 00:01:01,409 --> 00:01:05,109 look at the difference the check in the rain check out I 19 00:01:05,109 --> 00:01:09,049 and I want us to go to work out the duration of 20 00:01:09,049 --> 00:01:12,229 a stay so if you look at this one 21 00:01:12,228 --> 00:01:15,929 we've got checking that the $55 million the check out they have ninety 22 00:01:15,930 --> 00:01:19,189 we want to return the mountain Mikes stay 23 00:01:19,188 --> 00:01:23,798 well that would be tonight fifty not the sixteenth seventy 24 00:01:23,799 --> 00:01:27,430 and eighty not the night the 19th to the check out a 25 00:01:27,430 --> 00:01:31,700 so we would want his first record to return number for 26 00:01:31,700 --> 00:01:35,130 I would also on the second record for time for we want 27 00:01:35,129 --> 00:01:38,839 third to return 5 set researcher 28 00:01:38,840 --> 00:01:42,280 so how do we do that quite simple really we use 29 00:01:42,280 --> 00:01:45,909 the date the function so click in empty column 30 00:01:45,909 --> 00:01:50,250 critical builder first we're gonna name this duration 31 00:01:50,250 --> 00:01:53,879 Nicole on remember anything you cook for coal on 32 00:01:53,879 --> 00:01:57,468 with the name if the filled and 33 00:01:57,468 --> 00:02:01,209 free tap into day we go charging ahead you can see you got quite a few 34 00:02:01,209 --> 00:02:02,099 different 35 00:02:02,099 --> 00:02:05,618 I'm date functions you can use when we're interested in is 36 00:02:05,618 --> 00:02:09,179 to today's date this by recommend you to go through them to see if you can make 37 00:02:09,179 --> 00:02:09,770 some 38 00:02:09,770 --> 00:02:14,200 sensitive for my are okay so 39 00:02:14,199 --> 00:02:18,068 we've got take the function here CanoScan first to comment 40 00:02:18,068 --> 00:02:23,000 to see you can bring up work to bring up the sort of extra information 41 00:02:23,000 --> 00:02:27,830 we can see that we've got one to 3 arguments that we have to provide 42 00:02:27,830 --> 00:02:31,590 and a couple of optional ones and his face don't worry too about the optional 43 00:02:31,590 --> 00:02:32,189 ones 44 00:02:32,189 --> 00:02:35,900 I never used them the August we have to provide at the interval 45 00:02:35,900 --> 00:02:39,430 bait 1.82 date1 date2 46 00:02:39,430 --> 00:02:43,719 are days people to find a difference in so it's going to be checkin and checkout 47 00:02:43,719 --> 00:02:47,939 the interval is the kind of been too we want 48 00:02:47,939 --> 00:02:52,400 so for example you can so the date the function that you want to return the 49 00:02:52,400 --> 00:02:53,019 difference in 50 00:02:53,019 --> 00:02:56,719 days I'm or are you might only be interested 51 00:02:56,719 --> 00:03:01,348 in difference in months I have to do this to you I tend to 52 00:03:01,348 --> 00:03:04,530 University use day's most the time 53 00:03:04,530 --> 00:03:07,680 so maybe I'm not getting the most out my take two functions 54 00:03:07,680 --> 00:03:11,250 but I think I can live with it okay so interval 55 00:03:11,250 --> 00:03:14,908 I wanted to attend days and you refer to do that pits 56 00:03:14,908 --> 00:03:18,509 are top professional the 57 00:03:18,509 --> 00:03:22,128 double quotation mark that stays so you're passing 58 00:03:22,128 --> 00:03:25,378 a string variable to the function 59 00:03:25,378 --> 00:03:28,798 come up take one is check in date 60 00:03:28,799 --> 00:03:32,060 Qamar check out like 61 00:03:32,060 --> 00:03:35,340 to Plaza press OK 62 00:03:35,340 --> 00:03:39,189 I see just bring it back up perversely to 63 00:03:39,189 --> 00:03:42,729 so have a look at that duration code on date defrank send 64 00:03:42,729 --> 00:03:46,798 info is TN quotation marks and check in they 65 00:03:46,799 --> 00:03:51,450 check out they the check in then check out they refer to this check in to hear 66 00:03:51,449 --> 00:03:52,609 that check out they 67 00:03:52,610 --> 00:03:57,769 and if we run it you can see they returned for for the first time for for 68 00:03:57,769 --> 00:03:58,549 the second 69 00:03:58,549 --> 00:04:03,159 five for the first line which we can work ourselves but this gets bit more 70 00:04:03,158 --> 00:04:03,878 tricky 71 00:04:03,878 --> 00:04:07,060 when a really say but that's twenty nine nights 72 00:04:07,060 --> 00:04:10,060 this one's more tricky sixty four months 73 00:04:10,060 --> 00:04:14,170 okay so that's the date the function very useful functions to know about 74 00:04:14,169 --> 00:04:21,169 I'm who -9 Exchange Act sorry yeah I was a day to function very fun to to know 75 00:04:26,990 --> 00:04:27,500 about 76 00:04:27,500 --> 00:04:31,168 have a play around with some others take function see what you can make of them 77 00:04:31,168 --> 00:04:36,099 and and I sure hope to see nexidia offer save this