Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 23rd May 2017, 08:27
IndoTech's Avatar
IndoTech IndoTech is offline
Member
 
Join Date: Jul 2005
Posts: 72
IndoTech is on a distinguished road
Baan: Baan IV, Infor LN 10.4 - DB: SQL-Server2000, Oracle, Informix - OS: Windows NT, Unix
compare utc date and date without time
Baan: ERP LN 6.1 FP10 (Infor ERP 10.4)
C/S: Both

Hi All

Wants to compare the utc date date in tctax400.exdt with date from table tfacp935.ddat which is without date. for following query no result.
how to compare.
select tctax400.fovn
from tctax400
where tctax400._index1 = {:tfgld935.supl}
and tctax400.catg.l = tctax.catg.l.excise
and tctax400.efdt <= :tfgld935.ddat
and (tctax400.exdt = 0 or (tctax400.exdt >= :tfgld935.ddat))
as set with 1 rows
selectdo
ecc.no = strip$(tctax400.fovn)
endselect

Regards
Kedar
Reply With Quote
  #2  
Old 23rd May 2017, 12:15
srprks srprks is offline
Member
 
Join Date: May 2016
Location: Bangalore
Posts: 73
srprks is on a distinguished road
Baan: 10.4,Baan IV - DB: Oracle,SQL - OS: Unix,Windows
Hi

When you get tfgld935.ddat, just try to convert into utc variable with time 00:00:00 then you can compare in the query.


Thanks
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to ORDER BY on UTC date (and not time) TimoJanssen Tools Development 0 18th January 2013 00:45
Compare date with UTC vinmee Tools Development 3 19th April 2011 12:25
how to compare date and time? cucucucu Tools Development 27 16th April 2005 15:48
Time Conversion... suhas-mahajan Tools Development 6 8th October 2004 07:41
Time phased inventory movement date noonie Manufacturing & Supply Chain 0 20th February 2002 23:51


All times are GMT +2. The time now is 14:51.


©2001-2017 - Baanboard.com - Baanforums.com