Search found 4 matches

by repgen
Mon May 09, 2011 8:20 pm
Forum: ODBC
Topic: ODBC SQL Query CURRDATE -1
Replies: 2
Views: 1897

Re: ODBC SQL Query CURRDATE -1

UKMonkeyMAn
Thanks for your help. With a bit of help and tweaking I ended up with: ((TIMESTAMPDIFF(SQL_TSI_DAY,MK_01_ContactHistoryRecords.ContactDate,CURDATE())=1)
Thanks
by repgen
Thu Apr 28, 2011 4:03 pm
Forum: ODBC
Topic: ODBC SQL Query CURRDATE -1
Replies: 2
Views: 1897

ODBC SQL Query CURRDATE -1

I have this SQL selection as below but wish to look at ContactDate=CURDATE but for yesterday eg today -1. Having tried many options I still seem unable to get it to look at yesterdays date. Any help please SELECT MK_01_ContactHistoryRecords.ActivityCode, MK_01_ContactHistoryRecords.ContactDate, MK_0...
by repgen
Sat Nov 27, 2010 9:55 pm
Forum: Autoline
Topic: Simple Reporting
Replies: 1
Views: 1233

Re: Simple Reporting

A few items to check, 1st on the title tab is the check box set for Totals Only, 2nd on the sequence tab are you running any sort sequence and if so are the subtotals checked to total and 3rd on the format tab are the fields set to total in the definition. Without a bit more detail it would be diffi...
by repgen
Sun Oct 17, 2010 2:47 pm
Forum: Autoline
Topic: KCML / Autoline Rev 8
Replies: 1
Views: 1277

Re: KCML / Autoline Rev 8

I looks as if you need to create the terminal number in the terminal map table within management menu. Also don’t forget to create the terminal numbers in any POS companies as well if needed