Skip to content

Date Time display in UTC form instead of localtime #143

@zejili808

Description

@zejili808

Issue Overview

I have visitor enter a message with their name, message and pictures using Gravity Form (Basic). I then assigned the Entry Date to the Pods custom field submit_date with Form Field Entry Date. Here is the picture,
image My Memory Pod has a custom filed of submit_date with Field Type Date / Time. Here is a picture of the Pod and its fields:
image
I am using Elementor to display the field Submit Date and display it as a Custom Format. See this picture here,
image

The problem is the time is display in UTC and not localtime. Please advise. Thank you.

Expected Behavior

The time should be display in local time and not in UTC time.

Current Behavior

The time is display in UTC time.

Possible Solution

Steps to Reproduce (for bugs)

URL to the submit page: https://www.phys.hawaii.edu/sandip-pakvasa/submit_message/

Form Upload

``` {"0":{"title":"Messages_Form","description":"Messages of Memory","labelPlacement":"top_label","descriptionPlacement":"below","button":{"type":"text","text":"Submit","imageUrl":""},"fields":[{"type":"text","id":6,"label":"Full Name","adminLabel":"","isRequired":true,"size":"medium","errorMessage":"","visibility":"visible","inputs":null,"formId":1,"description":"Full Name","allowsPrepopulate":false,"inputMask":false,"inputMaskValue":"","inputMaskIsCustom":false,"maxLength":"","inputType":"","labelPlacement":"","descriptionPlacement":"","subLabelPlacement":"","placeholder":"","cssClass":"","inputName":"","noDuplicates":false,"defaultValue":"","choices":"","conditionalLogic":"","productField":"","enablePasswordInput":"","multipleFiles":false,"maxFiles":"","calculationFormula":"","calculationRounding":"","enableCalculation":"","disableQuantity":false,"displayAllCategories":false,"useRichTextEditor":false,"checkboxLabel":"","fields":"","displayOnly":"","personalDataExport":false,"personalDataErase":false},{"type":"textarea","id":3,"label":"Message","adminLabel":"","isRequired":true,"size":"medium","errorMessage":"","visibility":"visible","inputs":null,"formId":1,"description":"","allowsPrepopulate":false,"inputMask":false,"inputMaskValue":"","inputMaskIsCustom":false,"maxLength":1024,"inputType":"","labelPlacement":"","descriptionPlacement":"","subLabelPlacement":"","placeholder":"","cssClass":"","inputName":"","noDuplicates":false,"defaultValue":"","choices":"","conditionalLogic":"","productField":"","form_id":"","useRichTextEditor":false,"multipleFiles":false,"maxFiles":"","calculationFormula":"","calculationRounding":"","enableCalculation":"","disableQuantity":false,"displayAllCategories":false,"fields":"","displayOnly":"","personalDataExport":false,"personalDataErase":false},{"type":"fileupload","id":12,"label":"Picture - optional","adminLabel":"","isRequired":false,"size":"medium","errorMessage":"","visibility":"visible","inputs":null,"formId":1,"description":"","allowsPrepopulate":false,"inputMask":false,"inputMaskValue":"","inputMaskIsCustom":false,"maxLength":"","inputType":"","labelPlacement":"","descriptionPlacement":"","subLabelPlacement":"","placeholder":"","cssClass":"","inputName":"","noDuplicates":false,"defaultValue":"","choices":"","conditionalLogic":"","maxFileSize":"","maxFiles":"","multipleFiles":true,"allowedExtensions":"jpg,jpeg,png,gif","productField":"","calculationFormula":"","calculationRounding":"","enableCalculation":"","disableQuantity":false,"displayAllCategories":false,"useRichTextEditor":false,"checkboxLabel":"","fields":"","displayOnly":""},{"type":"captcha","id":7,"label":"CAPTCHA","adminLabel":"","isRequired":false,"size":"medium","errorMessage":"","visibility":"visible","inputs":null,"displayOnly":true,"formId":1,"description":"","allowsPrepopulate":false,"inputMask":false,"inputMaskValue":"","inputMaskIsCustom":false,"maxLength":"","inputType":"","labelPlacement":"","descriptionPlacement":"","subLabelPlacement":"","placeholder":"","cssClass":"","inputName":"","noDuplicates":false,"defaultValue":"","choices":"","conditionalLogic":"","productField":"","captchaType":"","captchaTheme":"","multipleFiles":false,"maxFiles":"","calculationFormula":"","calculationRounding":"","enableCalculation":"","disableQuantity":false,"displayAllCategories":false,"useRichTextEditor":false,"fields":""}],"version":"2.4.20.5","id":1,"nextFieldId":13,"useCurrentUserAsAuthor":true,"postContentTemplateEnabled":false,"postTitleTemplateEnabled":false,"postTitleTemplate":"","postContentTemplate":"","lastPageButton":null,"pagination":null,"firstPageCssClass":null,"subLabelPlacement":"below","cssClass":"","enableHoneypot":true,"enableAnimation":false,"save":{"enabled":false,"button":{"type":"link","text":"Save and Continue Later"}},"limitEntries":false,"limitEntriesCount":"","limitEntriesPeriod":"","limitEntriesMessage":"","scheduleForm":false,"scheduleStart":"","scheduleStartHour":"","scheduleStartMinute":"","scheduleStartAmpm":"","scheduleEnd":"","scheduleEndHour":"","scheduleEndMinute":"","scheduleEndAmpm":"","schedulePendingMessage":"","scheduleMessage":"","requireLogin":false,"requireLoginMessage":"","is_active":"1","date_created":"2020-09-29 06:06:00","is_trash":"0","personalData":{"preventIP":true,"retention":{"policy":"retain","retain_entries_days":1},"exportingAndErasing":{"columns":{"ip":{"export":false,"erase":false},"source_url":{"export":false,"erase":false},"user_agent":{"export":false,"erase":false}},"enabled":false,"identificationField":""}},"confirmations":[{"id":"5f72cec81de14","name":"Default Confirmation","isDefault":true,"type":"message","message":"Thank you for the submission.\u00a0 We will process it as soon as we can.","url":"","pageId":0,"queryString":"","disableAutoformat":false,"conditionalLogic":[]}],"notifications":[{"isActive":true,"name":"Admin Notification","service":"wordpress","event":"form_submission","to":"{admin_email}","toType":"email","cc":"","bcc":"","subject":"New memory submission from {Full Name:6}","message":"{all_fields}","from":"{admin_email}","fromName":"","replyTo":"","routing":null,"conditionalLogic":null,"disableAutoformat":false,"enableAttachments":false,"id":"5f72cec81d2d6"}],"feeds":{"pods-gravity-forms":[{"id":"1","form_id":"1","is_active":"1","feed_order":"0","meta":{"feedName":"Memory_feed","pod":"memory","pod_fields_submitter":"6","pod_fields_submitter_custom":"","pod_fields_submit_date":"date_created","pod_fields_submit_date_custom":"","pod_fields_message":"3","pod_fields_message_custom":"3","pod_fields_picture":"12","pod_fields_picture_custom":"","wp_object_fields_post_title":"6","wp_object_fields_post_title_custom":"","wp_object_fields_post_content":"3","wp_object_fields_post_content_custom":"","wp_object_fields_post_excerpt":"","wp_object_fields_post_excerpt_custom":"","wp_object_fields_post_author":"","wp_object_fields_post_author_custom":"","wp_object_fields_post_date":"","wp_object_fields_post_date_custom":"","wp_object_fields_post_name":"","wp_object_fields_post_name_custom":"","wp_object_fields_post_modified":"","wp_object_fields_post_modified_custom":"","wp_object_fields_post_parent":"","wp_object_fields_post_parent_custom":"","wp_object_fields_comments":"","wp_object_fields_comments_custom":"","wp_object_fields__thumbnail_id":"","wp_object_fields__thumbnail_id_custom":"","custom_fields":"","update_pod_item":"0","enable_markdown":"0","enable_current_post":"0","enable_prepopulate":"0","delete_entry":"1","feed_condition_conditional_logic":"0","feed_condition_conditional_logic_object":[]},"addon_slug":"pods-gravity-forms","event_type":null}]}},"version":"2.4.20.5"} ```

Pods Package Export

``` {"meta":{"version":"2.7.22","build":1601687915},"pods":{"106":{"id":106,"name":"memory","label":"Memories","description":"Condolence and Memory","type":"post_type","storage":"meta","object":"","alias":"","fields":{"submitter":{"id":107,"name":"submitter","label":"Submitter","description":"Whom submitted the memory","help":"","class":"","type":"text","weight":0,"pick_object":"","pick_val":"","sister_id":"","required":"1","text_allow_shortcode":"0","text_allow_html":"0","text_allowed_html_tags":"strong em a ul ol li b i","text_max_length":"255","pick_post_status":["publish"],"admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"rest_read":"0","rest_write":"0","rest_pick_response":"array","rest_pick_depth":"2","unique":"0","text_repeatable":"0","text_placeholder":""},"submit_date":{"id":108,"name":"submit_date","label":"Submit Date","description":"When memory was submitted","help":"","class":"","type":"datetime","weight":1,"pick_object":"","pick_val":"","sister_id":"","required":"1","datetime_type":"format","datetime_format":"mdy","datetime_time_type":"wp","datetime_time_format":"h_mma","datetime_time_format_24":"hh_mm","datetime_allow_empty":"0","datetime_html5":"0","pick_post_status":["publish"],"admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"rest_read":"0","rest_write":"0","rest_pick_response":"array","rest_pick_depth":"2","unique":"0","datetime_repeatable":"0","datetime_time_format_custom":"g:i a","datetime_format_custom":"","datetime_format_custom_js":"","datetime_time_format_custom_js":"","datetime_year_range_custom":""},"message":{"id":109,"name":"message","label":"Message","description":"Memory message","help":"","class":"","type":"wysiwyg","weight":2,"pick_object":"","pick_val":"","sister_id":"","required":"1","wysiwyg_editor":"tinymce","wysiwyg_media_buttons":"1","wysiwyg_oembed":"0","wysiwyg_wptexturize":"1","wysiwyg_convert_chars":"1","wysiwyg_wpautop":"1","wysiwyg_allow_shortcode":"0","pick_post_status":["publish"],"admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"rest_read":"0","rest_write":"0","rest_pick_response":"array","rest_pick_depth":"2","unique":"0","wysiwyg_repeatable":"0","wysiwyg_editor_height":"","wysiwyg_allowed_html_tags":""},"picture":{"id":161,"name":"picture","label":"Picture","description":"Photo memory of Sandip","help":"","class":"","type":"file","weight":3,"pick_object":"custom-simple","pick_val":"","sister_id":"","required":"0","file_format_type":"multi","file_uploader":"attachment","file_attachment_tab":"browse","file_edit_title":"1","file_show_edit_link":"1","file_linked":"1","file_limit":"0","file_restrict_filesize":"10MB","file_type":"images","file_field_template":"rows","file_add_button":"Add File","file_modal_title":"Attach a file","file_modal_add_button":"Add File","file_wp_gallery_output":"0","file_wp_gallery_link":"post","file_wp_gallery_columns":"1","file_wp_gallery_random_sort":"0","file_wp_gallery_size":"thumbnail","pick_post_status":["publish"],"admin_only":"0","restrict_role":"0","restrict_capability":"0","hidden":"0","read_only":"0","roles_allowed":["administrator"],"rest_read":"0","rest_write":"0","rest_pick_response":"array","rest_pick_depth":"2","unique":"0","file_allowed_extensions":""}},"show_in_menu":"1","label_singular":"Memory","public":"1","show_ui":"1","supports_title":"1","supports_editor":"0","publicly_queryable":"1","exclude_from_search":"0","capability_type":"post","capability_type_custom":"memory","capability_type_extra":"1","has_archive":"1","hierarchical":"0","rewrite":"1","rewrite_with_front":"1","rewrite_feeds":"0","rewrite_pages":"1","query_var":"1","can_export":"1","default_status":"publish","supports_author":"0","supports_thumbnail":"0","supports_excerpt":"0","supports_trackbacks":"0","supports_custom_fields":"0","supports_comments":"0","supports_revisions":"0","supports_page_attributes":"0","supports_post_formats":"0","built_in_taxonomies_category":"0","built_in_taxonomies_elementor_font_type":"0","built_in_taxonomies_elementor_library_category":"0","built_in_taxonomies_elementor_library_type":"0","built_in_taxonomies_happyfiles_category":"0","built_in_taxonomies_link_category":"0","built_in_taxonomies_post_tag":"0","menu_name":"Memory","menu_position":"5","menu_icon":"dashicons-buddicons-pm","show_in_nav_menus":"1","show_in_admin_bar":"1","pfat_enable":"0","pfat_run_outside_loop":"0","pfat_append_single":"append","pfat_filter_single":"the_content","pfat_append_archive":"append","pfat_filter_archive":"the_content","rest_enable":"0","read_all":"0","write_all":"0","has_archive_slug":"memory"}}} ```

Related Issues and/or PRs

Todos

  • Tests
  • Documentation

WordPress Environment

``` Debug Information

WordPress Version: 5.5.1

PHP Version: 7.4.11

MySQL Version: 5.5.5

Server Software: Apache/2.4.37 (centos) OpenSSL/1.1.1c SVN/1.10.2

Your User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:81.0) Gecko/20100101 Firefox/81.0

Session Save Path: /var/lib/php/session

Session Save Path Exists: Yes

Session Save Path Writeable: Yes

Session Max Lifetime: 1440

Opcode Cache:

Apc: No
Memcached: No
OPcache: Yes
Redis: No

Object Cache:

APC: No
APCu: No
Memcache: No
Memcached: No
Redis: No

WPDB Prefix: wp_13_

WP Multisite Mode: Yes

WP Memory Limit: 64M

Current Memory Usage: 16.698M

Current Memory Usage (real): 2.000M

Pods Network-Wide Activated: Yes

Pods Install Location: /sites/phys.dept/physwp/wp-content/plugins/pods/

Pods Tableless Mode Activated: No

Pods Light Mode Activated: No

Currently Active Theme: GeneratePress Pakvasa Child

Currently Active Plugins:

Ele Custom Skin: 3.0.0
Elementor: 3.0.11
Elementor Pro: 3.0.5
GenerateBlocks: 1.1.2
GP Premium: 1.12.1
Gravity Forms: 2.4.20.5
HappyFiles Pro: 1.4.1
Members: 3.1.3
Page Links To: 3.3.4
Pods - Custom Content Types and Fields: 2.7.22
Pods Gravity Forms Add-On: 1.4.3
Posts Table Pro: 2.2.1
Recent Posts Widget Extended: 0.9.9.7
Simple Custom CSS and JS: 3.33
Two Factor Authentication: 1.8.6
Ultimate Addons for Elementor: 1.27.0
Wordfence Security: 7.4.11
WP-Matomo Integration: 1.0.24
</details>

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions