Date Mapping Question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



I have a map whose destination schema is a flat file schema (I'm not
sure if that impacts my question or not). I have a source node that
is a DateTime datatype and a destination node that is a string. I
need the flat file to contain the date in the format yyyyMMdd.

Does anyone have any suggestions on the easiest way to accomplish
this?

I was hoping to find a functoid to help with date formatting, but did
not. I thought of using a scripting functoid and create some inline
c# that took the input parameter and concatenated the date parts into
my desired format, but was worried that it would produce an error if
the source node is empty (which is possible). In the case of an empty
source node, I would like the destination field to be empty as well.

Thanks for any help with this!

.



Relevant Pages

  • XSLT Conditional creation of destination Node
    ... The destination XML schema has an optional State element. ... if the source node is present but blank, I want to NOT create the ...
    (comp.text.xml)
  • Re: XSLT Conditional creation of destination Node
    ... The destination XML schema has an optional State element. ... if the source node is present but blank, I want to NOT create the ... I'm currently using Altova MapForce 2006 to do the development. ...
    (comp.text.xml)
  • RE: Mapping Issue
    ... There are examples in this newsgroup, you should be able to pick one and ... > have them in the first record of destination ... The next five record in the source schema will then go into the ... > So, if there are 18 records in the source node, ...
    (microsoft.public.biztalk.general)
  • Mapping Issue
    ... I have a source schema with looping records: ... second record of the destination node. ... So, if there are 18 records in the source node, ...
    (microsoft.public.biztalk.general)