Hi, may I know how I can change the expiry date field format in the email templates from yyyy-mm-dd to de-mm-yyyy? I have tried changing the date format in the text elements of the survey but that makes no difference to the expiry date field format. Can anyone advise if the format is fixed? Thanks in advance.

I have experienced the same issue and I cannot find it in settings.

I'm trying to include EXPIRY in the Reminder email template. This works:

{date('l\, F j\, Y',strtotime('2016-01-28'))}

This does NOT work:

{date('l\, F j\, Y',strtotime(EXPIRY))}

In fact, I can't even get this to work: {strtotime(EXPIRY)}, although if I "Validate expression in Reminder" it is able to show me the value of EXPIRY. Is there something else I must do to get it to evaluate EXPIRY in the expression?

What is your survey date format?

I find that {date('l\, F j\, Y',strtotime(EXPIRY))} works with the following formats:

• dd.mm.yyyy
• dd-mm-yyyy
• d-m-yyyy
• d.m.yyyy
• yyyy-mm-dd
• yyyy/mm/dd
• mm/dd/yyyy

The date for this particular survey is displayed as 28.01.2016 00:00. However, when I "Validate Expression in Reminder" and hover over EXPIRY it displays "; Value= 28.01.2016". Where do I change the survey date format?

Incidentally, this text: This survey will be closing on {date('l\, F j\, Y',strtotime('2016-01-28'))}. {strtotime(EXPIRY)}

Translates to this text in the email: This survey will be closing on Thursday, January 28, 2016. strtotime(EXPIRY)

And of course if I substitute the hard-coded date (2016-01-28) with EXPIRY then it translates to: This survey will be closing on date('l\, F j\, Y', strtotime(EXPIRY)). strtotime(EXPIRY)

The date format is set in Survey properties --> Edit text elements --> Date format

HI,

LimeSurvey version and build number ?

github.com/LimeSurvey/LimeSurvey/commit/...41989578c9d5aa451ad2

Denis

Version 2.06+ Build 151205

Can you please update to the latest release and retest?

That fixed it. Thanks!

I guess I should have tried that first.

I also trying to add expiry email in email template but I get junk HTML :

Anything you guess I am doing wrong...

Version 2.06+ Build 150612

Update : I got rid of junk html by changing the setting : Use HTML format for token emails? --> Yes , but it still shows {date('l\, F j\, Y',strtotime(EXPIRY))} . I have also tried with date format as mm/dd/yyyy .

OMdev wrote: Anything you guess I am doing wrong...

Version 2.06+ Build 150612

Fixed in 2.06_plus_151215

github.com/LimeSurvey/LimeSurvey/commit/...41989578c9d5aa451ad2

Did you read the topic ?

Yes , I did but didnt follow that link.. Got it now..

This is working fine. Thank you so much