Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Seems so simlpe! I want to use TODAY()

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Seems so simlpe! I want to use TODAY()
 Login/Join
 
RobertF
Master
posted
I have a column called: BillDate in my table. Its format is: HYYMDs.


I want a where condition:
WHERE BillDate <= TODAY[)

Do I define an item: TodaysDate using the today function? What would that look like?

No luck so far....

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
FP Mod Chuck
Virtuoso
posted Hide Post
Robert

This document may help you. https://techsupport.informatio...wbf/wbf_tcn_143.html


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005Report This Post
RobertF
Master
posted Hide Post
thanks, I could no doubt go thru the support center...was thinking this was something folks do all the time and might have the syntax for me.


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
FP Mod Chuck
Virtuoso
posted Hide Post
I haven't done it with a full date/timestamp before or I would have provided an example.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005Report This Post
RobertF
Master
posted Hide Post
for some reason it wont let me format TODAY('HYYMD') for comparison.

This message has been edited. Last edited by: RobertF,


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
RobertF
Master
posted Hide Post
ehh...simplest things take too much time.

This message has been edited. Last edited by: RobertF,


WebFOCUS 8206.08
Windows, All Outputs
 
Posts: 603 | Registered: June 28, 2013Report This Post
GamP
Virtuoso
posted Hide Post
TODAY is for standard date fields. for HYYMDs fields you should use HGETC. That will give yoy the date and time in a HYYMDS field whcih you can use for whatever purpose..


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
dbeagan
Platinum Member
posted Hide Post
You could try:
WHERE BillDate LE '&DATEYYMD 23:59:59.999'


WebFOCUS 8.2.06
 
Posts: 210 | Location: Sterling Heights, Michigan | Registered: October 19, 2010Report This Post
Waz
Expert
posted Hide Post
You could try 
WHERE BillDate LE DT(&YYMD|23599999)

Can't remember if its a string or number


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6349 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
sh98110
Gold member
posted Hide Post
I recently (sometime after our 82x upgrade) noticed that the following code will work:

WHERE RUN_DATE GE '&YYMD'

RUN_DATE defined as HYYMDS. The SQL that gets produced is:

WHERE
(T1."RUN_DATE" >= CAST('20201125 00:00:00' AS DATETIME));

This test is against SQL Server, but I am pretty sure it also works versus DB2. I am pretty sure that this did not always work, but it does now. Use of a literal, instead of the & variable, also works.

Nicely- the following code fails:

WHERE RUN_DATE GE '&MDYY'

the trace shows-

(FOC177) INVALID DATE CONSTANT: 11252020


WebFOCUS 8
Windows, All Outputs
 
Posts: 71 | Registered: May 29, 2015Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Seems so simlpe! I want to use TODAY()

Copyright © 1996-2020 Information Builders