{"id":10166,"date":"2016-02-25T09:51:02","date_gmt":"2016-02-25T01:51:02","guid":{"rendered":"http:\/\/localhost\/help\/p2-server\/calculations\/makedatetime\/"},"modified":"2024-01-17T10:48:03","modified_gmt":"2024-01-17T02:48:03","slug":"makedatetime","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/makedatetime\/","title":{"rendered":"MakeDateTime()"},"content":{"rendered":"\n<h2><span id=\"Format\">Format<\/span><\/h2>\n<p class=\"intro-text\"><strong>MakeDateTime(Year ,Month ,Day ,Hour ,Minute ,Second [,TimeZone])<\/strong><\/p>\n<h2><span id=\"Returns\">Returns<\/span><\/h2>\n<p class=\"intro-text\">Returns the specified date\/time as Unix epoch time.<\/p>\n<h2><span id=\"Parameters\">Inputs<\/span><\/h2>\n<p class=\"intro-text\"><strong>Year<\/strong>: A\u00a04-digit year (eg 2006).<br \/>\nBehaviour: Required<br \/>\nDimension: Collection, SingleValue, MultiCollection<br \/>\nValid\u00a0data types: Decimal, Integer<\/p>\n<p class=\"intro-text\"><strong>Month<\/strong>: A\u00a0value from 1 to 12 for January to December.<br \/>\nBehaviour:\u00a0Required<br \/>\nDimension: Collection, SingleValue, MultiCollection<br \/>\nValid\u00a0data types: Decimal, Integer<\/p>\n<p class=\"intro-text\"><strong>Day<\/strong>: The day of the month from 1 to 31.<br \/>\nBehaviour:\u00a0Required<br \/>\nDimension: Collection, SingleValue, MultiCollection<br \/>\nValid\u00a0data types: Decimal, Integer<\/p>\n<p class=\"intro-text\"><strong>Hour<\/strong>: A\u00a0value from 0 to 23.<br \/>\nBehaviour:\u00a0Required<br \/>\nDimension: Collection, SingleValue, MultiCollection<br \/>\nValid\u00a0data types: Decimal, Integer<\/p>\n<p class=\"intro-text\"><strong>Minute<\/strong>: A\u00a0value from 0 to 59.<br \/>\nBehaviour:\u00a0Required<br \/>\nDimension: Collection, SingleValue, MultiCollection<br \/>\nValid\u00a0data types: Decimal, Integer<\/p>\n<p class=\"intro-text\"><strong>Second<\/strong>: A\u00a0value from 0 to 59.<br \/>\nBehaviour:\u00a0Required<br \/>\nDimension: Collection, SingleValue, MultiCollection<br \/>\nValid\u00a0data types: Decimal, Integer<\/p>\n<p class=\"intro-text\"><strong>TimeZone<\/strong>: The geographical or UTC offset\u00a0time zone (e.g. \"Australia\/Perth\" or \"UTC+08:00\"). If not supplied, it assumes the configured calendar time zone.<br \/>\nBehaviour:\u00a0Optional<br \/>\nDimension: SingleValue<br \/>\nValid\u00a0data types: String<\/p>\n<p class=\"left-bar\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/calculation-syntax\/#Data_Type\">How to format data types<\/a><\/p>\n<h2>Examples<\/h2>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">MakeDateTime(2016,2,3,4,5,6,\"Australia\/Perth\")<\/span><br \/>\nResult:\u00a01454443506<\/p>\n<h2><span id=\"Release_History\">Release History<\/span><\/h2>\n<ul class=\"intro-text\">\n<li>MakeDateTime() 4.6.5\n<ul class=\"intro-text\">\n<li>Changed all parameters except TimeZone to support MultiCollection values.<\/li>\n<\/ul>\n<\/li>\n<li>MakeDateTime() 4.0\n<ul class=\"intro-text\">\n<li>Initial version<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Use MakeDateTime() to get a specified date\/time as Unix epoch time.<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/makedatetime\/\">Read more<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":10175,"parent":3650,"menu_order":129,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[9],"tags":[100,397,399],"class_list":["post-10166","page","type-page","status-publish","has-post-thumbnail","hentry","category-tech-ref","tag-calculations","tag-casting-functions","tag-date-based-functions","Version-4-0","Version-4-6-5","Product-srv"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/10166","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=10166"}],"version-history":[{"count":4,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/10166\/revisions"}],"predecessor-version":[{"id":64744,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/10166\/revisions\/64744"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/3650"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/10175"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=10166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=10166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=10166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}