Page 1 of 1

How to convert DATE in internal format for comparison

Posted: Thu Nov 11, 2004 12:29 pm
by ashcar
In server job we use Iconv and Oconv to do conversion of date and then compare between the internal values..
how can ido the same in parallel extender...
tried using DatetoString but does not work for me

please help

Posted: Thu Nov 11, 2004 2:43 pm
by ray.wurlod
Without using a stage type that supports BASIC expressions (such as the "BASIC Transformer" stage), the parallel extender does not support the concept of an internal format for dates.

You could, of course, create a buildop that uses substringing techniques to decompose the dates into "days since a certain day zero" and (perhaps a separate buildop) to compare them.

Re: How to convert DATE in internal format for comparison

Posted: Tue Nov 16, 2004 10:39 am
by mpouet
Hi,

Try "JulianDayFromDate", it is a kind of internal date.

Good luck
Matthieu

Posted: Wed Nov 17, 2004 12:58 am
by mandyli
Hi

Yes in PX you need to use normal transformer. use JulianDayFromDate () it will work.

Thanks
Man

Re: How to convert DATE in internal format for comparison

Posted: Wed Nov 17, 2004 1:15 am
by rameshDHL
ashcar wrote:In server job we use Iconv and Oconv to do conversion of date and then compare between the internal values..
how can ido the same in parallel extender...
tried using DatetoString but does not work for me

please help

We can still use Iconv and Oconv in parallel extender by using shared container. It will incorporate the functionalities into parallel extender. Other functions available are JulianDayfromDate DateFromJulianDay.

Posted: Tue Jul 12, 2005 2:41 am
by bchau
Hi I was wondering if there would be an error if I enter Feb 31 as the argument for JulianDayFromDate function. Or does it automatically convert it to Feb 28/29?