Originally posted by: SystemAdmin

Hi,

I have a rule that creates a date in s specific format, but sometimes it returns NONE !??

=DATETOTEXT(CURRENTDATETIME("{MMDDHH24MMSS}"))

Is this possible ?

I was told that the DATETOTEXT fucntion was not the best idea so I should use FROMDATETIME instead:

=FROMDATETIME(CURRENTDATETIME(), "{MMDDHH24MMSS}")

Can someone explain why the first doesn't work all the times ?

Thanks,
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

The only suggestion I would have is to specify the format string as shown below, since you do not have a year in your date portion of the datetime format string, .

Since you don't have a year at the beginning of the format string perhaps it gets confused under some circumstances as to what the leading MM represents.

If you use the Type Designer to build an item with the desired format, this is the way it is created.

=DATETOTEXT(CURRENTDATETIME("{MMDD}{HH24MMSS}"))
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange