Date formating in QGIS using expression?Does QGIS support parsing of date strings in tables?Date-format conversionAdd a certain number of days for a date fieldSelecting numbers within the slash (/) using ArcMap Field Calculator?Remove time stamp from date field using field calculatorMaking automatic updated date and time field in QGIS?QGIS filter by date in attribute tableQGIS: Symbolize by date field based on current date
In a jam session, when asked which key my non-transposing instrument (like a violin) is in, what do I answer?
Writing a letter of recommendation for a mediocre student
Safely hang a mirror that does not have hooks
Why there so many pitch control surfaces on the Piaggio P180 Avanti?
How to make interviewee comfortable interviewing in lounge chairs
Is it really necessary to have 4 hours meeting in Sprint planning?
How to create a grid following points in QGIS?
I reverse the source code, you negate the output!
Hiking with a mule or two?
Would Taiwan and China's dispute be solved if Taiwan gave up being the Republic of China?
Circle divided by lines between a blue dots
Are there hydrocarbons on the Moon?
Minimize taxes now that I earn more
Paradox regarding phase transitions in relativistic systems
How do I improve in sight reading?
Resolving moral conflict
Gas leaking in base of new gas range?
What was an "insurance cover"?
Is there any reason nowadays to use a neon indicator lamp instead of an LED?
Temporarily moving a SQL Server 2016 database to SQL Server 2017 and then moving back. Is it possible?
Can multiple wall timers turn lights on or off when required?
Nanomachines exist that enable Axolotl-levels of regeneration - So how can crippling injuries exist as well?
How do I reduce cost for a circular PCB shape?
Is there an in-universe reason Harry says this or is this simply a Rowling mistake?
Date formating in QGIS using expression?
Does QGIS support parsing of date strings in tables?Date-format conversionAdd a certain number of days for a date fieldSelecting numbers within the slash (/) using ArcMap Field Calculator?Remove time stamp from date field using field calculatorMaking automatic updated date and time field in QGIS?QGIS filter by date in attribute tableQGIS: Symbolize by date field based on current date
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
My expression:
day(now()) || '/' || month(now()) || '/' || year(now())
returns current date as 15/4/2019, but I want to get the date in dd/mm/yyyy format i.e. 15/04/2019.
How can I get that using QGIS desktop version 2.18.12?
qgis field-calculator qgis-processing
edited Apr 19 at 11:38
PolyGeo♦
55.2k17 gold badges88 silver badges259 bronze badges
asked Apr 15 at 13:18
Keshav SharmaKeshav Sharma
899 bronze badges
add a comment
|
My expression:
day(now()) || '/' || month(now()) || '/' || year(now())
returns current date as 15/4/2019, but I want to get the date in dd/mm/yyyy format i.e. 15/04/2019.
How can I get that using QGIS desktop version 2.18.12?
qgis field-calculator qgis-processing
edited Apr 19 at 11:38
PolyGeo♦
55.2k17 gold badges88 silver badges259 bronze badges
asked Apr 15 at 13:18
Keshav SharmaKeshav Sharma
899 bronze badges
add a comment
|
My expression:
day(now()) || '/' || month(now()) || '/' || year(now())
returns current date as 15/4/2019, but I want to get the date in dd/mm/yyyy format i.e. 15/04/2019.
How can I get that using QGIS desktop version 2.18.12?
qgis field-calculator qgis-processing
edited Apr 19 at 11:38
PolyGeo♦
55.2k17 gold badges88 silver badges259 bronze badges
asked Apr 15 at 13:18
Keshav SharmaKeshav Sharma
899 bronze badges
My expression:
day(now()) || '/' || month(now()) || '/' || year(now())
returns current date as 15/4/2019, but I want to get the date in dd/mm/yyyy format i.e. 15/04/2019.
How can I get that using QGIS desktop version 2.18.12?
qgis field-calculator qgis-processing
qgis field-calculator qgis-processing
edited Apr 19 at 11:38
PolyGeo♦
55.2k17 gold badges88 silver badges259 bronze badges
asked Apr 15 at 13:18
Keshav SharmaKeshav Sharma
899 bronze badges
edited Apr 19 at 11:38
PolyGeo♦
55.2k17 gold badges88 silver badges259 bronze badges
asked Apr 15 at 13:18
Keshav SharmaKeshav Sharma
899 bronze badges
edited Apr 19 at 11:38
PolyGeo♦
55.2k17 gold badges88 silver badges259 bronze badges
edited Apr 19 at 11:38
PolyGeo♦
55.2k17 gold badges88 silver badges259 bronze badges
edited Apr 19 at 11:38
PolyGeo♦
55.2k17 gold badges88 silver badges259 bronze badges
55.2k17 gold badges88 silver badges259 bronze badges
asked Apr 15 at 13:18
Keshav SharmaKeshav Sharma
899 bronze badges
asked Apr 15 at 13:18
Keshav SharmaKeshav Sharma
899 bronze badges
asked Apr 15 at 13:18
Keshav SharmaKeshav Sharma
899 bronze badges
899 bronze badges
add a comment
|
add a comment
|
1 Answer
1
active
oldest
votes
You need to use the format_date expression.
format_date(now(),'dd/MM/yyyy')
Please read the documentation of the format_date expression in QGIS Expression dialog to have all possibilities.
answered Apr 15 at 13:20
etrimailleetrimaille
2,1446 silver badges20 bronze badges
It returns date like 15/53/2019....which is impossible.
– Keshav Sharma
Apr 15 at 13:25
QGIS 2.18.12 is very old. The last of the 2.18 is 2.18.28 from January 2019. Maybe a bug has been fixed in the mean time? And QGIS 2.18 is not maintained anymore. Do you have theMMexpression in your expression dialog documentation?
– etrimaille
Apr 15 at 13:28
Yeah, 'MM' seems to be working fine, I think 2.18 wrongly reads 'mm'.
– Keshav Sharma
Apr 15 at 13:33
Thankyou for your help.
– Keshav Sharma
Apr 15 at 13:34
MMis working fine for me on 2.18.28
– etrimaille
Apr 15 at 13:34
add a comment
|
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f318837%2fdate-formating-in-qgis-using-expression%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You need to use the format_date expression.
format_date(now(),'dd/MM/yyyy')
Please read the documentation of the format_date expression in QGIS Expression dialog to have all possibilities.
answered Apr 15 at 13:20
etrimailleetrimaille
2,1446 silver badges20 bronze badges
It returns date like 15/53/2019....which is impossible.
– Keshav Sharma
Apr 15 at 13:25
QGIS 2.18.12 is very old. The last of the 2.18 is 2.18.28 from January 2019. Maybe a bug has been fixed in the mean time? And QGIS 2.18 is not maintained anymore. Do you have theMMexpression in your expression dialog documentation?
– etrimaille
Apr 15 at 13:28
Yeah, 'MM' seems to be working fine, I think 2.18 wrongly reads 'mm'.
– Keshav Sharma
Apr 15 at 13:33
Thankyou for your help.
– Keshav Sharma
Apr 15 at 13:34
MMis working fine for me on 2.18.28
– etrimaille
Apr 15 at 13:34
add a comment
|
You need to use the format_date expression.
format_date(now(),'dd/MM/yyyy')
Please read the documentation of the format_date expression in QGIS Expression dialog to have all possibilities.
answered Apr 15 at 13:20
etrimailleetrimaille
2,1446 silver badges20 bronze badges
It returns date like 15/53/2019....which is impossible.
– Keshav Sharma
Apr 15 at 13:25
QGIS 2.18.12 is very old. The last of the 2.18 is 2.18.28 from January 2019. Maybe a bug has been fixed in the mean time? And QGIS 2.18 is not maintained anymore. Do you have theMMexpression in your expression dialog documentation?
– etrimaille
Apr 15 at 13:28
Yeah, 'MM' seems to be working fine, I think 2.18 wrongly reads 'mm'.
– Keshav Sharma
Apr 15 at 13:33
Thankyou for your help.
– Keshav Sharma
Apr 15 at 13:34
MMis working fine for me on 2.18.28
– etrimaille
Apr 15 at 13:34
add a comment
|
You need to use the format_date expression.
format_date(now(),'dd/MM/yyyy')
Please read the documentation of the format_date expression in QGIS Expression dialog to have all possibilities.
answered Apr 15 at 13:20
etrimailleetrimaille
2,1446 silver badges20 bronze badges
You need to use the format_date expression.
format_date(now(),'dd/MM/yyyy')
Please read the documentation of the format_date expression in QGIS Expression dialog to have all possibilities.
answered Apr 15 at 13:20
etrimailleetrimaille
2,1446 silver badges20 bronze badges
answered Apr 15 at 13:20
etrimailleetrimaille
2,1446 silver badges20 bronze badges
answered Apr 15 at 13:20
etrimailleetrimaille
2,1446 silver badges20 bronze badges
answered Apr 15 at 13:20
etrimailleetrimaille
2,1446 silver badges20 bronze badges
2,1446 silver badges20 bronze badges
It returns date like 15/53/2019....which is impossible.
– Keshav Sharma
Apr 15 at 13:25
QGIS 2.18.12 is very old. The last of the 2.18 is 2.18.28 from January 2019. Maybe a bug has been fixed in the mean time? And QGIS 2.18 is not maintained anymore. Do you have theMMexpression in your expression dialog documentation?
– etrimaille
Apr 15 at 13:28
Yeah, 'MM' seems to be working fine, I think 2.18 wrongly reads 'mm'.
– Keshav Sharma
Apr 15 at 13:33
Thankyou for your help.
– Keshav Sharma
Apr 15 at 13:34
MMis working fine for me on 2.18.28
– etrimaille
Apr 15 at 13:34
add a comment
|
It returns date like 15/53/2019....which is impossible.
– Keshav Sharma
Apr 15 at 13:25
QGIS 2.18.12 is very old. The last of the 2.18 is 2.18.28 from January 2019. Maybe a bug has been fixed in the mean time? And QGIS 2.18 is not maintained anymore. Do you have theMMexpression in your expression dialog documentation?
– etrimaille
Apr 15 at 13:28
Yeah, 'MM' seems to be working fine, I think 2.18 wrongly reads 'mm'.
– Keshav Sharma
Apr 15 at 13:33
Thankyou for your help.
– Keshav Sharma
Apr 15 at 13:34
MMis working fine for me on 2.18.28
– etrimaille
Apr 15 at 13:34
It returns date like 15/53/2019....which is impossible.
– Keshav Sharma
Apr 15 at 13:25
It returns date like 15/53/2019....which is impossible.
– Keshav Sharma
Apr 15 at 13:25
QGIS 2.18.12 is very old. The last of the 2.18 is 2.18.28 from January 2019. Maybe a bug has been fixed in the mean time? And QGIS 2.18 is not maintained anymore. Do you have the
MM expression in your expression dialog documentation?– etrimaille
Apr 15 at 13:28
QGIS 2.18.12 is very old. The last of the 2.18 is 2.18.28 from January 2019. Maybe a bug has been fixed in the mean time? And QGIS 2.18 is not maintained anymore. Do you have the
MM expression in your expression dialog documentation?– etrimaille
Apr 15 at 13:28
Yeah, 'MM' seems to be working fine, I think 2.18 wrongly reads 'mm'.
– Keshav Sharma
Apr 15 at 13:33
Yeah, 'MM' seems to be working fine, I think 2.18 wrongly reads 'mm'.
– Keshav Sharma
Apr 15 at 13:33
Thankyou for your help.
– Keshav Sharma
Apr 15 at 13:34
Thankyou for your help.
– Keshav Sharma
Apr 15 at 13:34
MM is working fine for me on 2.18.28– etrimaille
Apr 15 at 13:34
MM is working fine for me on 2.18.28– etrimaille
Apr 15 at 13:34
add a comment
|
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f318837%2fdate-formating-in-qgis-using-expression%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
