[Qgis-user] Identifying day of week question

[Steven Campbell]

Hi all

 

Found my own answer. In case you're interested, If you use the
following: format_date("Date",'dddd') (putting your date column name in
the italics) then it identifies the day of the week from the date
supplied. Happy Days!

 

Steve

 

From: Steven Campbell 
Sent: 30 July 2013 12:33
To: qgis-user
Subject: Identifying day of week question

 

Hi

 

I have a dataset that has the date column within it, does anyone know of
a way to identify the day of the week that the date relates to so if
01-01-2013 is a Tuesday I want to create an extra column to display the
day name.

 

Any help would be greatly appreciated

 

Thanks!

 

Steve Campbell

GIS Manager

Corporate Strategy and Communications

Borough of Poole | Civic Centre | Poole BH15 2RU

Tel: 01202 633 362

Email: s.campbell at poole.gov.uk

Website:www.boroughofpoole.com <http://www.boroughofpoole.com/> 

Think Green! Please Recycle

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130730/d62ac759/attachment.html>