{"id":4128,"date":"2016-06-09T20:50:50","date_gmt":"2016-06-09T20:50:50","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=4128"},"modified":"2020-06-25T13:42:01","modified_gmt":"2020-06-25T20:42:01","slug":"parse-date-function","status":"publish","type":"post","link":"https:\/\/www.minisoft.com\/support\/parse-date-function\/","title":{"rendered":"Parse Date Function"},"content":{"rendered":"<p>The Parse Date function parses text representing a date or timestamp into a Julian timestamp that shows the number of milliseconds since 1\/1\/1970. The Date format field specifies the format of the text to evaluate. The format options are described in detail here: <a href=\"https:\/\/docs.oracle.com\/javase\/7\/docs\/api\/java\/text\/SimpleDateFormat.html\">https:\/\/docs.oracle.com\/javase\/7\/docs\/api\/java\/text\/SimpleDateFormat.html<\/a><\/p>\n<p><a href=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/parse-date.jpg\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-4129\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/parse-date.jpg\" alt=\"parse-date\" width=\"324\" height=\"158\" srcset=\"https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/parse-date.jpg 324w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/parse-date-300x146.jpg 300w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/parse-date-150x73.jpg 150w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/parse-date-250x122.jpg 250w\" sizes=\"(max-width: 324px) 100vw, 324px\" \/><\/a><\/p>\n<p>One use of this function is to compare dates. Set two variables to the following values:<\/p>\n<ul>\n<li>Date1 = 01\/04\/2017<\/li>\n<li>Date2 = 10\/11\/2016<\/li>\n<\/ul>\n<p>If you use a Greater Than or Less Than condition to test these dates, Date2 is the greater date because the values are compared as strings: 10 &gt; 01. Comparing these values as dates is easy:<\/p>\n<ol>\n<li>Add a Parse Date function to each variable. These dates are formatted the same way, so the Parse Date function is the same for both variables, MM\/dd\/yyyy. If your date is represented with a different format, see Date and Time Patterns below for help determining the correct representation for your data.<img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-5909 aligncenter\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/DateTest1-300x190.jpg\" alt=\"\" width=\"300\" height=\"190\" srcset=\"https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/DateTest1-300x190.jpg 300w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/DateTest1-150x95.jpg 150w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/DateTest1-250x158.jpg 250w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/DateTest1-284x180.jpg 284w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/DateTest1.jpg 330w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/li>\n<li>You can see in the Variables window that these values are converted to a Julian date representation that shows the number of milliseconds since 1 January 1970:\u00a0<img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-5911 aligncenter\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/DateTest2-300x80.jpg\" alt=\"\" width=\"300\" height=\"80\" srcset=\"https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/DateTest2-300x80.jpg 300w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/DateTest2-150x40.jpg 150w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/DateTest2-250x67.jpg 250w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/DateTest2.jpg 427w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/li>\n<li>Date1 and Date2 can now be compared.<\/li>\n<\/ol>\n<p>More information of how to use the Parse Date function is available at\u00a0<a href=\"\/support\/index.php\/date-calculation-procedure-video-only\/\">https:\/\/minisoft.com\/support\/index.php\/date-calculation-procedure-video-only\/<\/a>.<\/p>\n<h2>Parsing dates with &#8220;th&#8221;, &#8220;nd&#8221;, &#8220;rd&#8221;, &#8220;st&#8221; or other letter combinations<\/h2>\n<p>If a date is alphanumeric, use of eFORMz business rules (conditional logic) is likely necessary.<\/p>\n<p><a href=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date1.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-6676\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date1.png\" alt=\"\" width=\"273\" height=\"46\" srcset=\"https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date1.png 273w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date1-150x25.png 150w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date1-250x42.png 250w\" sizes=\"(max-width: 273px) 100vw, 273px\" \/><\/a><\/p>\n<p>Letters must be escaped by quotes:<\/p>\n<pre>\u2018th,\u2019<\/pre>\n<p><a href=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date2.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-6677\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date2.png\" alt=\"\" width=\"314\" height=\"192\" srcset=\"https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date2.png 314w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date2-300x183.png 300w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date2-150x92.png 150w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date2-250x153.png 250w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date2-294x180.png 294w\" sizes=\"(max-width: 314px) 100vw, 314px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date3.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-6678\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date3.png\" alt=\"\" width=\"341\" height=\"149\" srcset=\"https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date3.png 341w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date3-300x131.png 300w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date3-150x66.png 150w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date3-250x109.png 250w\" sizes=\"(max-width: 341px) 100vw, 341px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date5.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-6680\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date5.png\" alt=\"\" width=\"429\" height=\"93\" srcset=\"https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date5.png 429w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date5-300x65.png 300w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date5-150x33.png 150w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2016\/06\/Date5-250x54.png 250w\" sizes=\"(max-width: 429px) 100vw, 429px\" \/><\/a><\/p>\n<h2>Date and Time Patterns<\/h2>\n<div style=\"direction: ltr;\">\n<table style=\"direction: ltr; border-collapse: collapse; margin-left: .3333in; border: 0pt solid #A3A3A3;\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\"><span style=\"font-weight: bold;\">Letter <\/span><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\"><span style=\"font-weight: bold;\">Date or Time Component <\/span><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\"><span style=\"font-weight: bold;\">Presentation <\/span><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\"><span style=\"font-weight: bold;\">Examples <\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">G<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Era designator<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#text\"><span style=\"font-size: 10.0pt;\">Text<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">AD<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">y<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Year<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#year\"><span style=\"font-size: 10.0pt;\">Year<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">1996; 96<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">M<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Month in year<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#month\"><span style=\"font-size: 10.0pt;\">Month<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">July; Jul; 07<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">w<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Week in year<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#number\"><span style=\"font-size: 10.0pt;\">Number<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">27<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">W<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Week in month<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#number\"><span style=\"font-size: 10.0pt;\">Number<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">2<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">D<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Day in year<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#number\"><span style=\"font-size: 10.0pt;\">Number<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">189<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">d<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Day in month<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#number\"><span style=\"font-size: 10.0pt;\">Number<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">10<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">F<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Day of week in month<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#number\"><span style=\"font-size: 10.0pt;\">Number<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">2<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">E<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Day in week<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#text\"><span style=\"font-size: 10.0pt;\">Text<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Tuesday; Tue<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">a<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Am\/pm marker<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#text\"><span style=\"font-size: 10.0pt;\">Text<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">PM<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">H<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Hour in day (0-23)<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#number\"><span style=\"font-size: 10.0pt;\">Number<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">0<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">k<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Hour in day (1-24)<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#number\"><span style=\"font-size: 10.0pt;\">Number<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">24<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">K<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Hour in am\/pm (0-11)<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#number\"><span style=\"font-size: 10.0pt;\">Number<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">0<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">h<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Hour in am\/pm (1-12)<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#number\"><span style=\"font-size: 10.0pt;\">Number<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">12<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">m<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Minute in hour<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#number\"><span style=\"font-size: 10.0pt;\">Number<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">30<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">s<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Second in minute<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#number\"><span style=\"font-size: 10.0pt;\">Number<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">55<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">S<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Millisecond<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#number\"><span style=\"font-size: 10.0pt;\">Number<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">978<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">z<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Time zone<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#timezone\"><span style=\"font-size: 10.0pt;\">General time zone<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Pacific Standard Time; PST; GMT-08:00<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Z<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Time zone<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/6\/docs\/api\/java\/text\/SimpleDateFormat.html#rfc822timezone\"><span style=\"font-size: 10.0pt;\">RFC 822 time zone<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">-0800<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border-width: 0pt; vertical-align: top; width: .6673in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">X<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.7055in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">Time zone<\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 1.2881in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri;\"><a href=\"https:\/\/docs.oracle.com\/javase\/7\/docs\/api\/java\/text\/SimpleDateFormat.html#iso8601timezone\"><span style=\"font-size: 10.0pt;\">ISO 8601 time zone<\/span><\/a><\/p>\n<\/td>\n<td style=\"border-width: 0pt; vertical-align: top; width: 2.4715in; padding: 4pt 4pt 4pt 4pt;\">\n<p style=\"margin: 0in; font-family: Calibri; font-size: 10.0pt;\">-08; -0800; -08:00<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>The Parse Date function parses text representing a date or timestamp into a Julian timestamp that shows the number of milliseconds since 1\/1\/1970. The Date format field specifies the format of the text to evaluate. The format options are described in detail here: https:\/\/docs.oracle.com\/javase\/7\/docs\/api\/java\/text\/SimpleDateFormat.html One use of this function is to compare dates. Set two [&hellip;]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[66,10],"tags":[202,339,201],"_links":{"self":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/4128"}],"collection":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=4128"}],"version-history":[{"count":14,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/4128\/revisions"}],"predecessor-version":[{"id":8118,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/4128\/revisions\/8118"}],"wp:attachment":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=4128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=4128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=4128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}