Date Entry format

I'm not totally sure what it is you are asking, but if you want the date to display as dd mm yyyy, simply change the code in your viewer to read as such:

<?php echo date("d m Y", strtotime($record['fieldname']))?>

Make sure you change 'fieldname' to read the same as whatever the field name is for your date field.

Hope this is of some help.

Jim

Do you want to use that format for showing dates on your website or for the form fields that a user enters a date into?

There's no automatic day to change the form fields right now but you could move their order around by editing /lib/menus/default/edit_functions.php (make a backup first then search for "use24HourFormat" to find the place where the date fields are displayed).

Hope that helps!

Thanks Kate and Dave...

I'll wait for this feature because it is very important to users of my region.

Date entry field must have "DD-MM-YYYY" entry format and showing format too....

[unimpressed]

Hi jamtc,

And how should time be shown on the entry format? And is it 12 hour or 24 hour?

Hi Dave !

24hs like this: "23:59:30"

[:)]

Ok, I'll put this on the list for v1.24.

In the meantime, you can set 24 hour format in the field editor, and if you are comfortable editing PHP you can edit this file (make a backup) to swap the date field order:

/cmsAdmin/lib/menus/default/edit_functions.php

- make backup of file
- open file for editing
- search for ":mon"
- find these two lines:

print " <select name='{$fieldSchema['name']}:mon'>$monthOptions</select>\n";
print " <select name='{$fieldSchema['name']}:day'>$dayOptions</select>\n";

and swap them like this:

print " <select name='{$fieldSchema['name']}:day'>$dayOptions</select>\n";
print " <select name='{$fieldSchema['name']}:mon'>$monthOptions</select>\n";

Hope that helps!