14 calls to PHPExcel_Shared_Date::ExcelToPHP() in Loft Data Grids 7.2

PHPExcel_Calculation_DateTime::DATE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php

* DATE * * The DATE function returns a value that represents a particular date. * * NOTE: When used in a Cell Formula, MS Excel changes the cell format so that it matches the date * format of your regional settings. PHPExcel does not change…

PHPExcel_Calculation_DateTime::DATENOW in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php

* DATENOW * * Returns the current date. * The NOW function is useful when you need to display the current date and time on a worksheet or * calculate a value based on the current date and time, and have that value updated each time you *…

PHPExcel_Calculation_DateTime::DATEVALUE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php

* DATEVALUE * * Returns a value that represents a particular date. * Use DATEVALUE to convert a date represented by a text string to an Excel or PHP date/time stamp * value. * * NOTE: When used in a Cell Formula, MS Excel changes the cell…

PHPExcel_Calculation_DateTime::EDATE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php

* EDATE * * Returns the serial number that represents the date that is the indicated number of months * before or after a specified date (the start_date). * Use EDATE to calculate maturity dates or due dates that fall on the same day of the…

PHPExcel_Calculation_DateTime::EOMONTH in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php

* EOMONTH * * Returns the date value for the last day of the month that is the indicated number of months * before or after start_date. * Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month. * *…

PHPExcel_Calculation_DateTime::HOUROFDAY in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php

* HOUROFDAY * * Returns the hour of a time value. * The hour is given as an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.). * * Excel Function: * HOUR(timeValue) * *

PHPExcel_Calculation_DateTime::MINUTEOFHOUR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php

* MINUTEOFHOUR * * Returns the minutes of a time value. * The minute is given as an integer, ranging from 0 to 59. * * Excel Function: * MINUTE(timeValue) * *

PHPExcel_Calculation_DateTime::SECONDOFMINUTE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php

* SECONDOFMINUTE * * Returns the seconds of a time value. * The second is given as an integer in the range 0 (zero) to 59. * * Excel Function: * SECOND(timeValue) * *

PHPExcel_Calculation_DateTime::TIME in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php

* TIME * * The TIME function returns a value that represents a particular time. * * NOTE: When used in a Cell Formula, MS Excel changes the cell format so that it matches the time * format of your regional settings. PHPExcel does not change…

PHPExcel_Calculation_DateTime::TIMEVALUE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php

* TIMEVALUE * * Returns a value that represents a particular time. * Use TIMEVALUE to convert a time represented by a text string to an Excel or PHP date/time stamp * value. * * NOTE: When used in a Cell Formula, MS Excel changes the cell…

PHPExcel_Calculation_DateTime::WORKDAY in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/DateTime.php

* WORKDAY * * Returns the date that is the indicated number of working days before or after a date (the * starting date). Working days exclude weekends and any dates identified as holidays. * Use WORKDAY to exclude weekends or holidays when…

PHPExcel_Shared_Date::ExcelToPHPObject in vendor/phpoffice/phpexcel/Classes/PHPExcel/Shared/Date.php

* Convert a date from Excel to a PHP Date/Time object * *

PHPExcel_Worksheet_AutoFilter::_filterTestInDateGroupSet in vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet/AutoFilter.php

* Test if cell value is in the defined set of Excel date values * *

PHPExcel_Worksheet_AutoFilter::_filterTestInPeriodDateSet in vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet/AutoFilter.php

* Test if cell date value is matches a set of values defined by a set of months * *