×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
The problem with %CHAR is that it outputs a different length based on
the value of the number (rather than the length of the field).
Shouldn't matter for a YEAR, since a year will probably always be a
4-digit number. But... you don't want to use it for a month or day,
since these will sometimes be 1-digit and sometimes 2-digit.
But, even with %CHAR, I think the formula is more complicated than it
needs to be. I'd rather see the following (as I posted in a previous
message)
pr_year = %rem(%subdt(iso_date:*Y): 100);
Michael_Schutte@xxxxxxxxxxxx wrote:
Try %Char instead...
%dec(%subst(%char(%subdt(iso_date:*y)):3:2):2:0)
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
