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
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 23rd May 2017, 07: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
Sponsored Links
  #2  
Old 23rd May 2017, 11:15
srprks srprks is online now
Member
 
Join Date: May 2016
Location: Bangalore
Posts: 61
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
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 17th January 2013 23:45
Compare date with UTC vinmee Tools Development 3 19th April 2011 11:25
how to compare date and time? cucucucu Tools Development 27 16th April 2005 14:48
Time Conversion... suhas-mahajan Tools Development 6 8th October 2004 06:41
Time phased inventory movement date noonie Manufacturing & Supply Chain 0 20th February 2002 22:51


All times are GMT +2. The time now is 07:20.


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