Strange behaviour Calendar field

[marcorensch]

Hi at all, i'm currently struggeling while creating a working datetime field for my component.
In fact it "reverses" the given date and saves it in a totaly wrong string order inside the db:
What i select in the calendar:

What i have after save:

How its saved in the db:

The field format should be: %d.%m.%Y (German DE format)
My field settings are actually:
default: NOW
format: true (should not been used because see below)
filter: STRING
translateformat: true
showtime: false

For me it looks like the field does not adapt the visible format to the SQL format and puts the numbers in as given (for sure that was not the case before) - i have already tried to complete the affected fields and re-created them from scratch. I've tried to disable the translateformat and used hardcoded format in field settings but the effect still remains the same...

Am i just to dumb or is there a bug?

[Llewellynvdm]

The date field is one of those fields that need extra help at times. JCB does nothing to model this field, it is all Joomla and if the outcome is not what you expected you should use the expert modeling option in the field to model the field yourself.

I have seen other developers face the same issue and they had very hard workarounds. But the expert modeling option gives you the ability to model the field before you save it and again when you retrieve it (if need be) from the database.

So this is what I used at times:

if (isset([[[field]]]) && ([[[field]]] != '0000-00-00 00:00:00') && ([[[field]]] != ''))
{
	[[[field]]] = JFactory::getDate([[[field]]])->toSql();
}

Then my field setup looks like this:

[Llewellynvdm]

Since the get modeling will want something... this is what I add:

[marcorensch]

i know there was a video about that but i did not find it currently, When i set the on Save model as you described it is also used in the backend export, there where an if statement you have used in one of your videos if its not export. Can you please point me into the right direction?

Edit i found the vid: https://www.youtube.com/watch?v=fau5mZ6naLc&list=PLQRGFI8XZ_wtGvPQZWBfDzzlERLQgpMRE&index=28

and i tried this, but its not working as expected:

if(!isset($_export) || !$_export){
if (isset([[[field]]]) && ([[[field]]] != '0000-00-00 00:00:00') && ([[[field]]] != ''))
{
	[[[field]]] = JFactory::getDate([[[field]]])->toSql();
}
}else{
[[[field]]] = [[[field]]];
}

[marcorensch]

Solved now:
I had in the Admin View Field Relations setted a rule to overwrite the date display, so i've changed it there:

// [1031]=> Active from
if(!isset($_export) || !$_export){
	$item->{1031} = Joomla\CMS\HTML\HTMLHelper::date(
		$item->{1031}, Joomla\CMS\Language\Text::_('DATE_FORMAT_FILTER_DATE')
	);
}else{
	// nothing to change
}

Admin Views --> My view --> Fields --> Field relations --> Model (before modelling) rule