Skip to Content Skip to Menu

[SOLVED] Problem with date field

9 years 4 months ago - 9 years 4 months ago #266310 by diplomesiaelille
[SOLVED] Problem with date field was created by diplomesiaelille
Hello,

I just noticed that when someone subscribe to my website there is a problem with the registration of birth dates.

example:
Someone signs up with a date of September 6, 90

In the database will be shown : 5 September 90

If someone can help me :)

Cdt
Sébastien
Last edit: 9 years 4 months ago by krileon.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
9 years 4 months ago - 9 years 4 months ago #266330 by krileon
Replied by krileon on topic Problem with date field
Date fields offset by timezone by default. In the case of birth dates you shouldn't offset. You can disable the offset within Parameters > Display while editing your date field in CB > Field Management.

Someone signs up with a date of September 6, 90

That's their localized date, which is offset by their offset or by server offset.

In the database will be shown : 5 September 90

That's the UTC date. Date fields always store as UTC. They store as UTC and display as local.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Last edit: 9 years 4 months ago by krileon.
The following user(s) said Thank You: diplomesiaelille

Please Log in or Create an account to join the conversation.

9 years 4 months ago #266342 by diplomesiaelille
Replied by diplomesiaelille on topic Problem with date field
Thx a lot !!!

It's working again :)

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon
Powered by Kunena Forum