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
Problem while converting into date to string format
Moderators: chulett, rschirm, roy
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:
MonthNumber is the extracted month from the date.
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)
Thanks Arndw,
your formula is good
your formula is good
ArndW wrote: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:
MonthNumber is the extracted month from the date.Code: Select all
Field('January,February,March,...",",",MonthNumber)