I have WebFocus 8.1 and I need to calculate the birth date of my records. Using whatever the current date is at the time the person runs the report. What is the syntax for today's date or current date when the person runs the report.This message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8 Windows, All Outputs
March 20, 2017, 04:56 PM
Doug
Check out the "DATEADD" function.
March 20, 2017, 05:06 PM
Waz
OR possibly DATEDIF or HDIFF depending on the source format.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
March 20, 2017, 05:32 PM
Doug
Excellent Waz.
quote:
Or possibly DATEDIF or HDIFF
The clarity that brings matches the number of Posts I have: 2020 ( Nerdy, I know )