7

SQL is the best option to bulk update the entries. But you must need to be careful as wrong execution can stress you up! You can use below query: UPDATE exp_channel_titles SET status = 'created' WHERE status = 'open' AND channel_id = '1' AND entry_date <= '1262332799' Replace the date value with UNIX timestamps of the date and channel_id you want ...


4

In your entry_date tag you're using (date formatting docs): %m (month) %F (month, textual, 3 letters) %Y (year, 4 digits) So it's outputting as you've entered it. If you want 19 may 2014, change %m to %d like: {entry_date format="%d %F %Y"}


3

Your date format is incorrect. Please check https://ellislab.com/expressionengine/user-guide/templates/date_variable_formatting.html. Your format there provides (%F, long month) Feburary (%n, month without leading zeros) 2 (%Y, four digit year) 2015. So yes, February is always the 2nd month, and the year isn't going to change during that month. I think ...


2

You can try MX Calc {exp:mx_calc expression="{current_time} - 600 "} {if entry_date > {calc_result}} .... {/if} {/exp:mx_calc} but still, this is not good solution because whats happens if user will refresh page many times in accepted timeframe? The perfect solution is made small plugin which will do indication that for current entry message was ...


2

If you can overcome your objections to using the native Entry Date I'd definitely opt for using that... However, if you want to essentially rebuild the month_links functionality yourself, you could do this with Stash (yet again!). Try something like this, using two nested get_list tags: (if you're using an embedded view template you won't need the stash:...


2

try DATE_FORMAT(from_unixtime(entry_date), '%Y-%m-%d') AS post_date


2

You could enable php, grab the current time and add as much time as you need, then use the start_on parameter. Or here's a plugin you could use: http://devot-ee.com/add-ons/dt-plugin Maybe something like this as the start_on parameter: {exp:dt day="7" ee_format="true" format="%Y-%m-%d %H:%i"}


2

Update: Wes Baker posted, that there are "official solutions". In ..../system/expressionengine/libraries/Localize.php around line 283 remove the following block of code: if ( ! empty($date_string) && ! is_numeric($date_string) && @strtotime($date_string) === FALSE) { return FALSE; } And: Open system/expressionengine/...


2

I believe, your options are: to change the format of date you're using on the segment_2, which isn't a good idea because EllisLab can some day finally normalize all date fields; to reformat the date to match the way its used on edit_date database column; To change the date format, I suggest you the Low Nice Date plugin: {exp:low_nice_date date="{segment_2}...


2

I have spoken with Vector media about this issue and it has been determined to be a bug that resulted due to changes in the date functions from EE2 to EE3. This issue should be addressed in future releases of Cartthrob. The actual cause of the difference in dates is below: /cartthrob/models/cartthrob_entries_model.php has a public function (starting LINE ...


1

Not natively within EE's standard tags. Entry dates are stored as timestamps though so you could use a maths plugin to add on 7776000000 (90 days in milliseconds) then use date formatting to turn that into a nice date. But that's getting a bit "tag soupy" so you might be better off with a custom plugin that would return the modified, formatted date for you....


1

Head on over to your EE backend. If you go to Admin -> Localization Settings, you should set your default date format, and make sure to hit save to make it updated. It should be set to mm/dd/yy See if that does the trick. Edit: In 2.9.3, it even shows the full four year format, so make sure you set it to mm/dd/yyyy


1

You could use conditionals and the date format function to extract the month from the date and output a different season. Of course you would then need to define seasons by the start/end of months. It's down to how precise you wish to be. For instance; {if "{entry_date format='%n'}" > 1 AND "{entry_date format='%n'}" < 5} It's Spring(ish) (...


1

what you can do is to add some transcribe variables so you can generate language codes. make on like transcribe_lang_country with the value "en" and one like transcribe_lang_language with the value "US" (this is for the american english language version. I don't know the spanish ones) then let the locale be determined by the browser by adding the country ...


Only top voted, non community-wiki answers of a minimum length are eligible