Hi all

Are there any expressions I can use to format the out put of date fields such as {VALIDUNTIL} and {VALIDFROM}?


For example, the raw output is: 2019-12-18 11:38:00


We'd like to format as: 18 December.


If some detail is available I could have a go at updating the wiki.

I've been trying:

{date_format(VALIDUNTIL, 'd F Y')}

but this returns a blank. I was using the information at www.w3schools.com/PHP/func_date_date_format.asp

..but is there somewhere else for a full list of supported expressios I should be looking?

The validate expression function in the email templates seems to suggest date_format is supported.

Expression didn't have date_format function.

But you can use date and strtotime function

Try
{date('d F Y',strtotime(VALIDUNTIL))}

PS: VALIDUNTIL or VALIDFROM variables can be used only in email template

Thanks Dennis, worked like a charm.

Is there an alphabetical list of all the functions available anywhere? I think even a raw list of alphabetical of entries people could cross reference with online PHP manuals we be very helpful.

For example, in our case, there is some coding we've done in Java in the question section that we could probably shift to PHP if we knew the full functionality available.

Cheers!

Indispirit wrote: Is there an alphabetical list of all the functions available anywhere? I think even a raw list of alphabetical of entries people could cross reference with online PHP manuals we be very helpful.

If you click on the link of my previous post : www.limesurvey.org/manual/Expression_Man...#Access_to_Functions

Else : we have on inside LimeSUrvey, but since UI is broken and whole are not testes, show in the menu only with debug >2
=> You can put a feature request to to have it somewhere in LimeSurvey admin UI

Thanks - can see dateformat is on the "Functions that are Planned or Being Considered" list too.

Indispirit wrote: Thanks - can see dateformat is on the "Functions that are Planned or Being Considered" list too.

Well, in LS4 Denis did some coding to expose PHP functions more easily to ExpressionScript (ExpressionManager). That will bring new life to the "Functions that are planned or being considered".