Do you have SWING Integrator experience?
If you have experience with SWING Integrator and Microsoft Excel, more specifically experience in writing formulas from Notes to MS Excel I would be VERY happy to hear from you. We have a major issue with an application due for launch. It seems like the SWING Integrator code removes the equal-signs in from of the formulas thus rendering them unusable in Excel.
The formula is a concatenation of two dates from the Date functions (the funny å-character is the Danish stand-in for year (år)):
=concatenate(text(date(2006;11;8); "dd-mm-åååå"); " - "; text(date(2006;11;19); "dd-mm-åååå"))
(If I remove the equal-sign in front of the formula the text is written correctly to Excel so I think the issue stems from how SWING Integrator handles formulas.)
Heeeeeelp!
Re: Do you have SWING Integrator experience?
I have mostly used Word with Swing, not Excel - so I'm not quite sure where you are looking to use the above Excel formula. I assume this is on the Field Mapping tab of the Template setup form.
With both Word and Excel we use Notes formulas for any calculations. I believe you can also use Lotusscript in the formula