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

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 49

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 23rd May 2017, 07:27
IndoTech's Avatar
IndoTech IndoTech is offline
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 = strip$(tctax400.fovn)

Reply With Quote
Sponsored Links
Old 23rd May 2017, 11:15
srprks srprks is offline
Join Date: May 2016
Location: Bangalore
Posts: 82
srprks is on a distinguished road
Baan: 10.4,Baan IV - DB: Oracle,SQL - OS: Unix,Windows

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

Reply With Quote

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 01:31.

©2001-2018 - -