[Qgis-user] Date formula in Layout label

[b.j.kobben at utwente.nl]

in these dialogs, double-quating is for variable (column) names, single quoting for strings (like most expression builders and eg. also in SQL)...
...and you are correct, this is not stated in any obvious place, that should be made more clear!


--
Barend Köbben


On 11/06/2019, 13:08, "Qgis-user on behalf of DelazJ" <qgis-user-bounces at lists.osgeo.org<mailto:qgis-user-bounces at lists.osgeo.org> on behalf of delazj at gmail.com<mailto:delazj at gmail.com>> wrote:

Hi,

Reading the help of the format_date function, the second argument should be a string, and I'm not sure that "yyyy-MM-dd HH:mm" is necessarily read as string in this context. I actually don't know what it's read as.

Le mar. 11 juin 2019 à 11:19, Patrick Dunford <enzedrailmaps at gmail.com<mailto:enzedrailmaps at gmail.com>> a écrit :

It works, but it makes no sense
Then please open an issue report if not yet done, to get it fixed.

Regards,
Harrissou

Anyway thanks
On 11/06/19 12:30 AM, Phil Wyatt wrote:
Hi Patrick,

Try changing the double quotes to single quotes and I think it should work (in QGIS3)

format_date( $now,'yyyy-MM-dd HH:mm')

Cheers - Phil

From: Qgis-user [mailto:qgis-user-bounces at lists.osgeo.org] On Behalf Of Patrick Dunford
Sent: Monday, 10 June 2019 8:31 PM
To: qgis-user ML
Subject: [Qgis-user] Date formula in Layout label


Good day

When I create a layout and put a text label in it I want to be able to show the current date using a formula. This formula can look something like [%format_date( $now,"yyyy-MM-dd HH:mm")%]

I have to put this in square brackets so that the formula is executed instead of it just appearing as plain text. However when displayed on the page, the square brackets are included in the output. How do I get rid of them so that I just have the numbers of the date and time displayed?
_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org<mailto:Qgis-user at lists.osgeo.org>
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190611/f9305930/attachment.html>