Is date conversion possible?

Djohnson

Djohnson

Well Known Member
JDE output is a standard mm/dd/yyyy format. Is there a way in FormScape to convert for example: 10/11/2007 to October 11, 2007.

Reason: European customer confusion!
confused.gif


Thanks in advance.
 
We decided to use the JDE User Profile Revision page where the user him/herself can decide what date format to utilize. Works well and DOES pass through correctly to the FormScape form.
cool.gif
 
I took a different approach - modified the E1 report to convert date and place it into three string fields: Day, Month and Year.
And yes, I left padded days and months (with 0) if they're less than 10
cool.gif

Now FormScape has everything is needed to print in whichever format we want (we use three outputs / languages: English, French, and Spanish). This way I (having an English Profile) can print a French/Spanish output
grin.gif
 
Yes, You can do this with the options in the time variable

or combining this with a sentence
 
Back
Top