[SOLVED] Converting CYYMMDD to Serial Value

I'd convert it to a WebFOCUS date format (where the 1st "1" is "20") and use the Almost 1001 things you can do with dates...

Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005

Ignored post by Doug posted

Virtuoso

posted

Michael,
Try this:

  
DEFINE FILE CAR
IBM/I7=1130312;
CIBM/I8YYMD=19000000 + IBM;
FIBM/DMYY=CIBM;
END
TABLE FILE CAR
PRINT FIBM
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL2K
END

Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006

Ignored post by Danny-SRL posted

Michael_86

Member

posted

Hi Guys,

Thanks for the responses,

I also spoke to the support guys and their answer was to concat, cast and substr the date to create the output I want, not overly pretty but it works.

Danny, your code looks cool however im struggling to implement it as I write in SQL script as opposed to using WF. Is IBM meant to be a defined field? or is it created by me first?

Thanks

Webfocus 7.7.03
Windows
Excel

Posts: 21 | Registered: February 08, 2013

Ignored post by Michael_86 posted

Virtuoso

posted

Michael,
Yes "IBM" is a DEFINEd field.
Pardon my saying so, but why write in SQL script? Let WF do the work instead of "concat, cast and substr"!
I only use SQL as a last resort.

Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006

Ignored post by Danny-SRL posted

Michael_86

Member

posted

Hi Danny,

Thanks i'll see if I can give it a try.

The reason I'm writing in SQL script is because I was trained in SQL in my last work, and I have never used WF before and have been unable to find a basic training guide for simple report writing. So using the knowledge I have and putting it to use in the best way I can.

Michael

Webfocus 7.7.03
Windows
Excel

Posts: 21 | Registered: February 08, 2013

Ignored post by Michael_86 posted

FrankDutch

Virtuoso

posted

SQL is fine to collect the data although webfocus is much easier
After the data collection you still need to write your report which is more then the data.
Or is somebody doing that in excel? Brrrr...

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7

Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006

Ignored post by FrankDutch posted

Virtuoso

posted

Michael,
Take a week's holiday over here: see the sights and learn WebFOCUS!

Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006

Ignored post by Danny-SRL posted

Michael_86

Member

posted

Frank - As I work in accounts all im really using this for is data mining, after extraction it is put into excel to populate our Financial Statements, and also I use it to pull out transactional data which I can then review and investigate easier in excel than in our accounting system (Good Old Chorus!)

Danny - You're on!

if only I could get the holiday...

Webfocus 7.7.03
Windows
Excel

Posts: 21 | Registered: February 08, 2013

Ignored post by Michael_86 posted

Virtuoso

posted