{oapdf_gg}
(a) remove the current system time / date information for out the current system time / date information are mainly a function of NOW, TODAY. grammatical form are function names (). (b) obtain the date / time part of field values if separate years, months, days or hours of data, you can use the HOUR, DAY, MONTH , YEAR function directly from the date / time to retrieve the data needed. Specific examples see Figure 5. For example, the need to return 2001-5-30 12:30 PM the year, month, days and hours, can be used to achieve the corresponding functions. YEAR (E5) = 2001 MONTH (E5) = 5 DAY (E5) = 30 HOUR (E5) = 12 |