How do we change the date stamp format in email templates ?

[turner2f]

How do we change the date stamp format in email templates ?

We took look in the manual and in the forums and found ...

https://docs.blesta.com/display/user/Order+System


Currently it is set to ..

{invoice.date_due}	The UTC datetime stamp of the invoice due date	Formatted as "YYYY-MM-DD HH:MM:SS"
{invoice.date_billed}	The UTC datetime stamp of the invoice bill date	Formatted as "YYYY-MM-DD HH:MM:SS"

Which displays something like...

2016-12-21 05:00:00

===============================

1) - Exactly where and how do we change this format so that it is more clearly read in a format familiar to our clients ?

We would like the format to look something like...

MM-DD-YYYY HH:MM:SS

So that the output looks like ...

12-21-2016 at 5:00 PM

 

===============================

2) - Would changing this affect any of the "Automation" functions ?

[Michael]

Try: {invoice.date_due_formatted} not sure about the other you could try {invoice.date_billed_formatted}

[turner2f]

Used both of those tags and they came out blank on the " Invoice Delivery (Unpaid) " email template .

1) - Is there a setting within the admin panel that I need to look at ?
 

2) - Or will these tags only work in a particular email template ?

[turner2f]

 

{invoice.date_due_formatted}

Only seems to work in the following templates:

Auto-Debit Pending

Invoice Notice (1st)

Invoice Notice (2nd)

Invoice Notice (3rd)

====================

Is there a way to get this tag to work with the " Invoice Delivery (Unpaid) " email template ?

[turner2f]

---

 

[Paul]

https://docs.blesta.com/display/user/Customizing+Emails#CustomizingEmails-SupportedFilters

for date I think you want to follow this https://github.com/speedmax/h2o-php/wiki/Built-in-filters

Quote

date

syntax: date(format=“Y M d”)

Returns a string formatted according to the given format string using the given integer timestamp or the current time if no timestamp is given.
where format is the same as PHP date() function http://www.php.net/date

 

[turner2f]

We are aware of the date format.

What we are asking about is concerning the following tag ...

 

{invoice.date_due_formatted}

This tag only seems to work in the following templates:

Auto-Debit Pending

Invoice Notice (1st)

Invoice Notice (2nd)

Invoice Notice (3rd)

====================

Is there a way to get this tag to work with the " Invoice Delivery (Unpaid) " email template ?

[Paul]

16 hours ago, turner2f said:

We are aware of the date format.

What we are asking about is concerning the following tag ...

 

{invoice.date_due_formatted}

This tag only seems to work in the following templates:

Auto-Debit Pending

Invoice Notice (1st)

Invoice Notice (2nd)

Invoice Notice (3rd)

====================

Is there a way to get this tag to work with the " Invoice Delivery (Unpaid) " email template ?

No. You can use the date filter.

[turner2f]

We might know what you mean.

But could you direct us to where the "Date Filter" is ( or what it is ) so we can verify ?

[Paul]

11 minutes ago, turner2f said:

We might know what you mean.

But could you direct us to where the "Date Filter" is ( or what it is ) so we can verify ?

I already did, 

 

[turner2f]

Okeey.

Under Settings - - > general - - > localization

our settings are....

Date Format :  M d, Y

Date Time Format :  M d, Y g:i:s A

==================

Is this the AREA you are referring to implement this " Date Filter " ?

If yes, it did not work.

==================

1) - So just curious to know if you will be making the {invoice.date_due_formatted} work with the " Invoice Delivery (Unpaid) " email template ?

2) - Or is this "Date Filter" somewhere within the Blesta code that has to be modified, if yes, exactly where ? And what would the modified code look like ?

 

[Paul]

The date filter is a filter that can be added to the date tag inside the email template per the docs. So, you'd probably want something like:

{invoice.date_due | date "Y M d"}

Replacing the "Y M d" with the date format you want from http://www.php.net/date