I'm on my knees begging for a solution... Help!

All I want to do is change the date format from yyyy/mm/dd to dd/mm/yyy across my Dolphin installation.

That means;

The Profile page

Date of Birth when editing (that will allow the submission of the form without errors)

Date of Birth when joining (that will allow the submission of the form without errors)

In all modules (Browse Events by day, Browse profiles by date, Browse Blogs by day, Browse Ads post by day etc) making changes in the admin does not change the date format for all dates.

I have been looking for a week now, can someone please help me? Please.

Thanks

Log into your Dolphin Admin Panel then go to Advanced Settings > Variables.  you should see the date formats in there.  You said that you wanted your formats changed to dd/mm/yyyy.  From my recollection, those are the default settings for Dolphin.

Anyway, that is where you change the dates.  After doing this, be sure to log in via FTP to manually clear your caches, then be sure to clear your browser cache as well.

- Ulysses Chico Chapman

Nations Best Designs

Thank you very much for your reply,

Yes, you are correct the settings in admin Advanced Settings > Variables are dd/mm/yyyy by default but they do no affect things like Registration Date, Last Login Date, Last profile edition date on the Profile page or change the format for the date of birth field when editing profile or joining. Neither do they affect the Browse date shown in Events, Blogs, Ads etc modules.

All I want to do place the right date format across my website, that's all. Currently it's a mixture of yyyy/mm/dd and dd/mm/yyyy. It should be so simple?

Thanks

No. Not so simple. If dolphin is not following the settings in admin, then they are hard codeing it in the dolphin code. Which of course means going through all the code.

Soon you will learn that dolphin can do anything, but it's not always easy. And what might seem easy is quite often not.

Agreed, it's not so simple.

Has anyone managed to change the date format across their website? If so please let me know how you did it.

Please help, I'm desperate.

I would also like to change the format

I actually fixed mine myself. It took some work but paid off.

What I did was went into admin>variables>and switch all everything around. But before I did that I copy and paste everything in Microsoft Word and then one by one switch the formats around. For example the short date format(for code was Y.d.m what I did was flip it to m.d.Y as you can see below the new format which is now working perfectly. I hated the dolphin time format.

Time Format(for code):
Short Date Format(for code):
Long Date Format(for code):
Time Format(for database):
Short Date Format(for database):

Thanks, but making changes in the admin does not change

Browse Events by day

Browse profiles by date

Browse Blogs by day

Browse Ads post by day etc

Registration Date:

Last Login Date:

Last profile edition date:

Date of Birth (In profile edit and joining)

Where oh where do you make changes for the above.

I managed to change the date format for the profile edit page, but doing this prevented the form from being submitted and an error stating "You cannot be older than 75 years".

Why is changing the date format becoming a nightmare?

Help!!!

http://www.boonex.com/trac/dolphin/ticket/2355

is still a bug - it looks like dolphin - is the cms with more de bug

Thank you so much houstonlively for your posting, you can't believe how much that is appreciated, brings tears to my eyes

It's such a small thing, but I can't launch my website because of it. I'm going to have to wait for version 7.0.5 when they fix it (hopefully).

These values has full month name and year even without date, so it shouldn't be a problem for anyone to understand it incorrectly, for example: January, 2011.

Anyway, if you want to make corrections here you can try to change the following code in inc/classes/BxDolCalendar.php file

function getTitle () {
return $this->sMonthName . ', ' . $this->iYear;
}

It will be fixed - thank you for reporting, also other places will be checked.

Date of birth format is not used for entering date directly -  calendar is used to enter the date, also changing is not possible since this value is saved to database and database used this format.

I am truly touched by your help. Thank you all.

I will definitely be looking out for the next version when this issue should have been addressed.

Thanks again

If you have rep contact them and will help you especially Luvybol

No, I don't have a rep... how do I get one?

I'm seeing a bright white light at the end of this tunnel and I am walking towards it.

the problem is solved

regarder le tiket de houstonlively

http://www.boonex.com/trac/dolphin/ticket/2355

click on  -   r14817

and the solution -  direct link

http://www.boonex.com/trac/dolphin/changeset/14817

My heart was beating fast when I saw this post by danielmarseille and immediately implemented it.

I must say that this has happened very quickly but here is the result of implementation.

Old format: 2010-12-27 01:46:17

New format: 27.12.2010.01:46


So we are almost there

The fix applies to the dates on the profile page, as for dates elsewhere, I guess they are still to come.

to change the style

admin/Settings/Advanced Settings/Variables

Long Date Format(for code):d / m / Y  - H:i

Hurray... we have success on the profiles page. Yes!

I now have the date format on my profile page looking like this;

Registration Date: 27-12-2010 01:46

Last Login Date: 07-01-2011 16:11

Last profile edition date: 31-12-2010 05:31

Isn't it a thing of beauty

Thanks danielmarseille for the formatting info, just a few more date format changes and I will be in Heaven.

These are the date/time setings I use:

Time Format(for code): h:i a

Short Date Format(for code): F d, Y h:i a

Time Format(for database): %H:%i

Short Date Format(for database): %m..%d..%Y

Long Date Format(for database): %m..%d..%Y %H:%i

PHP date format: F j, Y

PHP Date Code Definitions

Time:

• a: am or pm depending on the time
• A: AM or PM depending on the time
• g: Hour without leading zeroes. Values are 1 through 12.
• G: Hour in 24-hour format without leading zeroes. Values are 0 through 23.
• h: Hour with leading zeroes. Values 01 through 12.
• H: Hour in 24-hour format with leading zeroes. Values 00 through 23.
• i: Minute with leading zeroes. Values 00 through 59.
• s: Seconds with leading zeroes. Values 00 through 59.

Day:

• d: Day of the month with leading zeroes. Values are 01 through 31.
• j: Day of the month without leading zeroes. Values 1 through 31
• D: Day of the week abbreviations. Sun through Sat
• l: Day of the week. Values Sunday through Saturday
• w: Day of the week without leading zeroes. Values 0 through 6.
• z: Day of the year without leading zeroes. Values 0 through 365.

Month:

• m: Month number with leading zeroes. Values 01 through 12
• n: Month number without leading zeroes. Values 1 through 12
• M: Abbreviation for the month. Values Jan through Dec
• F: Normal month representation. Values January through December.
• t: The number of days in the month. Values 28 through 31.

Year:

• L: 1 if it's a leap year and 0 if it isn't.
• Y: A four digit year format
• y: A two digit year format. Values 00 through 99.

Thanks houstonlively, for the dates and settings information that you provided. This is turning out to be a great thread.

I have now been able to format the long dates (with times) on the profile as follows

10 January 2011, 14:42 (d F Y, H:i)

The short date is formatted thus

28/12/2010 (d/m/Y)

I truly believe that we are almost there with the date formatting issue. I feel a lot more at ease now knowing the that the most visible and noticeable dates and time are formatted and are configurable.

I love icing, so I am waiting to have my fill when the icing on the cake (the other dates in the various modules) are equally configurable from the admin.

I don't even show dates on the profile, so I've never really paid much attention to this before.

houstonlivel... Out of curiosity, what is the date format in these locations on your site?

Events/Blogs/Ads > Calendar > Click on one of the calendar listings.

What's the date format after it says "Browse Events/Blogs/Ads By Day/Date:"?

The date format is Y-n-j   Ex: 2010-12-1 ..... a format that I have specified nowhere.   I reopened the above ticket, and will continue to do so, until this is properly fixed, or until I get suspended for being a nuisance.

Much appreciated, I hope you can see why I was pulling my hair out. Be persistent but don't get banned.

I think all the module need checking.

Why don't you post here, every place you find a date format that doesn't follow any of the date formats set in admin.

I had a look at the files:

modules/boonex/ads/classes/BxAdsModule.php

modules/boonex/blogs/classes/BxBlogsModule.php

I changed the respective lines of code from:

$sCaption = _t('_bx_blog_caption_browse_by_day') . "{$iValue1}-{$iValue2}-{$iValue3}";

$sCaption = _t('_bx_ads_caption_browse_by_day') . "{$iValue1}-{$iValue2}-{$iValue3}";

To:

$sCaption = _t('_bx_blog_caption_browse_by_day') . "{$iValue2}-{$iValue3}-{$iValue1}";

$sCaption = _t('_bx_ads_caption_browse_by_day') . "{$iValue2}-{$iValue3}-{$iValue1}";

This just changes the way the date is displayed.  It really needs to be changed by Boonex to use the date formats in admin, which will require a bit more recoding than just swapping the order of the variables.

If you go to the calendar view for the follow sections of you site and click on one of the listing, the date format shown above each item is yyyy-mm-dd and there is currently no way of changing this format from within the admin.

People
Blogs
Ads
Events
Groups
Sites
Store
Polls

houstonlively has found where to change the date formats in the code for the Ads and Blogs section, the others have not been located yet.

Can we all help in locating the other date format locations in the code?

Hopefully, Boonex will take this info and update Dolphin soon so that all date formats can be modified in the admin.

Note: The titles for these pages also include the date formatting information.

What I did for Blogs and Ads was just a hack, and should not be construed as any type of fix.  The date format in the areas you speak of, does not get its format from the admin settings, and that is what really needs to be fixed.  Hopefully, it won't take a bunch of recoding.  It needs to be done though, because date formats are a very basic thing, that needs to be consistent throughout the site.

I have uploaded the latest modification to the code that address the date formatting issues.

As far as I can see there is an error.

If you go to Files > Calendar > Click on one of the calendar listings, the heading reads as follows

"_bx_files_caption_browse_by_day: 09/01/2011"

As you can see instead of reading "All files" or "Browse files by day" it says "_bx_files_caption_browse_by_day"

How do I pass this on for correction?

That's a language key issue, and is not the fault of the change set.  You might try clearing your cache directory. I uploaded the new change set without issue.

I have a upload the fix but I'm still getting  "_bx_videos_caption_browse_by_day: 07 Jan 2011" being displayed at the top box when doing the following. Even though I have cleared the cache.

Files > Calendar > Click on one of the calendar listings

Photo> Calendar > Click on one of the calendar listings

Video> Calendar > Click on one of the calendar listings

Could you check and see if you have any anomalies?

You need to recompile modules' language files. Go to admin panel -> tools  -> modules -> select all installed modules and click "Recompile Languages"

Thank you, that did it.

All date formats are now configurable from admin except for date of birth which I am going change in the code. I will post the changes made once I have it working on my website.

I would be nice if the date of birth was configurable too.

Hello Stoosh,
I also have the same problem.
I know that this problem will be ok in version 7.05
Read here: http://www.boonex.com/unity/forums/?action=goto&my_threads=1#topic/Calendar-in-join-page.htm
However, as soon as you have the solution post it here

Thanks

For date DateOfBirth you need to change:

1. Date format for JS Date Picker in inc/js/jquery.webForms.js -> addWebForms method -> line 137
2. Date parser in profile fields in inc/classes/BxDolProfileFields.php -> processPostValues method -> line 111



inc/js/jquery.webForms.js (changed for date format dd/mm/yyyy)
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


// Date picker
if(this.getAttribute("type") == "date") {
$(this).attr('readonly', 'readonly').datepicker({
changeYear: true,
dateFormat: 'dd-mm-yy',
defaultDate: -8030,
yearRange: ($(this).attr('min') ? $(this).attr('min') : '1900') + ':' + ($(this).attr('max') ? $(this).attr('max') : '2100')
});
}

// DateTime picker
if(this.getAttribute("type") == "datetime") {
$(this)
.attr('readonly', 'readonly')
.dynDateTime({
ifFormat: '%d-%m-%y %H:%M:%S',
showsTime: true
});
}

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++






inc/classes/BxDolProfileFields.php (changed for date format dd/mm/yyyy)
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


case 'date':
if( isset( $_POST[$sItemName] ) and isset( $_POST[$sItemName][$iHuman] ) and trim( $_POST[$sItemName][$iHuman] ) !== '' ) {
list( $iDay, $iMonth, $iYear ) = explode( '-', $_POST[$sItemName][$iHuman] ); // 1985-10-28

$iDay = intval($iDay);
$iMonth = intval($iMonth);
$iYear = intval($iYear);

$mValue = sprintf("%04d-%02d-%02d", $iDay, $iMonth, $iYear);
}
break;

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


Let me know how you get on?

ALWAYS BACKUP FIRST

Thanks stoosh,
I can just try your solution and let you know.

Can someone confirm as of Dolphin 7.0.5 setting date format using fields below in Admin > Advanced Settings > Variables works for dates/times across an entire site?

• Time Format(for code)
• Short Date Format(for code)
• Long Date Format(for code)
• Time Format(for database)
• Short Date Format(for database)
• Enable member menu
• Long Date Format(for database)
• PHP date format

Also, can someone explain what for code, for database and PHP date format mean?

Thanks!

i can tell you without even wasting my time looking. that will be a big fat NO.

dolphin was graced with the Date Fairy at some point, and hard coded date formats are in literally thousands of pages on dolphin. that little tidge they put on the admin panel, is just to lead you to believe that it works across the site.

now the last part of your question i will look into, however, seems the first part of my answer would moot your second question anyhow.

Yes, it works everywhere in 7.0.5, exception is date field on join/profile edit form, like DateOfBirth !

for code format please refer to: http://php.net/manual/en/function.date.php

for database format please refer to: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format

AlexT,

What does PHP date format mean (relative to format for code and format for database)?

Thanks

HL has already defined these differences. the difference is just what you see, its the syntax convention used for code, database, and php

Has anyone found a solution for the Date of Birth format  on join page or profile edit yet?

I, too, need to know how to change the date format on the Join page. Please help!

I believe I just figured it out.I changed the date formats listed in inc/js/jquery.webForms.js, and that seems to have done the trick:

            // Date picker
            if(this.getAttribute("type") == "date") {
                $(this).datepicker({                   
                    changeYear: true,
                    dateFormat: 'yy-mm-dd',
                    defaultDate: -8030,
                    yearRange: ($(this).attr('min') ? $(this).attr('min') : '1900') + ':' + ($(this).attr('max') ? $(this).attr('max') : '2100')
                });

                if( this.getAttribute("allow_input") == null) {
                   $(this).attr('readonly', 'readonly');
                }
            }
           
            // DateTime picker
            if(this.getAttribute("type") == "datetime") {
               $(this)
                .dynDateTime({
                    ifFormat: '%Y-%m-%d %H:%M:%S',
                    showsTime: true
                });

                if( this.getAttribute("allow_input") == null) {
                   $(this).attr('readonly', 'readonly');
                }
            }

Crap, I spoke too soon. When I go to edit my profile and I select a birthday, it presents an error message that I cannot be more than 70 years old. I chose a date that would make me 30 years old. It seems as though it was reading the month part as the year in m-d-Y.

Anyone got any bright ideas? I don't see why this item needs to be so complicated.

Anyone? I can't believe there still isn't any answer for something that should be incredibly easy to switch.

 I know!!!  It is SOO FREAKING ANNOYING!!!  Back in D6 days they had a Mod that had drop down menu options.  I wish the Boonex team can focus on a free Tip to fix this issue.  It is so unprofessional the way it is.  Well to me that is =)

Didn't see this thread before, even i searched... so i opened a new one some days ago. :(

Anyway, i have the same problems and need find a solution for the registration or profile edit page. According to the DatePicker / jquery website this all can be done by language-config-files which the project also offers. The only problem i have is, how do i tell the dolphin code to use it?

http://jquery-ui.googlecode.com/svn/trunk/ui/i18n/jquery.ui.datepicker-de.js (german init example)

even dolphin comes with one for russian

/plugins/jquery/ui.datepicker-ru.js

The only thing i want to have is german users get the german format, and all others the standard one. I think someone from Boonex just need to tell us how to switch these init-files based on the browser or index page language