www.spansoft.org

SpanSoft help and discussion forums.
It is currently Sun Apr 30, 2017 10:06 am

All times are UTC [ DST ]




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Comparison date query
PostPosted: Wed Jan 29, 2014 12:24 pm 
Offline

Joined: Wed Jan 29, 2014 12:08 pm
Posts: 2
Location: Western Australia
Hi,
I have the following query which works fine:
SELECT Families.[Code], Families.[Fathers name], Families.[Mothers name], Families.[Change date], Families.[Changed]
FROM Families
WHERE ( Families.[Change date] < JDATE('1 jan 2003') )
Order by Families.[Change date]

I would like to change the query so I don't have to change the date. Ideally I would like it to be say ten years ago. I tried using Dateadd(years,-10,curdate()) and other 'googled' variations without success.

Is this possible?


Top
 Profile  
 
PostPosted: Wed Jan 29, 2014 12:46 pm 
Offline

Joined: Sun Dec 18, 2005 10:36 am
Posts: 638
Location: SpanSoft, Scotland
Hi,

Sorry. This sort of date comparison is not possible. Dates must be converted to julian dates in the format used internally by K&KPro and only literal dates can appear inside a JDATE() function. See Kith and Kin Pro manual - SQL Syntax


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group