How to convert DATE in internal format for comparison

[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

[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.

[mpouet]

Hi,

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

Good luck
Matthieu

[mandyli]

Hi

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

Thanks
Man

[rameshDHL]

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.

[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?