Problem while converting into date to string format

[hhh]

Hello Friends,

i want to convert date into string with format of <month name><dd><yyyy' but there is no function for convert Full month name from date value field ex. 11-12-2004 Then Output like December 11 2004.
In Transformer stage i have used DateToString Function and used 'mmm' but it takes upto 3 characters of month name, however my requirement is for whole month name.
If any Function,routine in Px which can directly convert into necessary format so please let me know.

Thanks
Hiten

[ArndW]

Hiten,

PX has no built-in function to do this; you could either write your own in C++ or you would need to code it into the job. The following would work:

Code: Select all

Field('January,February,March,...",",",MonthNumber)

MonthNumber is the extracted month from the date.

[hhh]

Thanks Arndw,
your formula is good

Hiten,

PX has no built-in function to do this; you could either write your own in C++ or you would need to code it into the job. The following would work:

Code: Select all

Field('January,February,March,...",",",MonthNumber)

MonthNumber is the extracted month from the date.

[kumar_s]

Hi,
Another workaround is create a seperate table and to do a lookup for each month.

regards
kumar

[ArndW]

Kumar,

using a lookup file/table would work, but would be much slower. I think that an IF...THEN...ELSE construct would also work, and would be fast if you could order the statements by order of frequency.