Skip to main content
  • EN
Hi,

 

 

I Used a DateFormatter  to export MS Access data in the source format (DD/MM/YYYY)

 

eg 02/12/2014

 

 

Entered (%d%m%Y)

 

            (%d%/%m%/Y)

 

 

Parameters

 

Data Attributes: DateField

 

Date Format: (%d%m%Y)

 

Source Format: DD/MM/YYYY

 

 

The output is: 20140122000000.000 - The output should be 2/12/2014

 

 

Any suggestions??

 

 

Thanks,

 

 

Clive
Hi Clive,

 

 

Generally, FME readers translate a datetime value into a character string of "yyyymmddHHMMSS" or "yyyymmddHHMMSS.nnn" format automatically.

 

If you are using the Access reader, connect an Inspector transformer to the reader feature type and check the datetime format with the Data Inspector.

 

 

Takashi
Dont use automatic detection. That automaticaly puts all the zeroes.

 

Your second line ?

 

(%d%/%m%/Y) => (%d/%m/%Y)
Hi Gio,

 

 

How do you disable the automatic detection??

 

 

Regards,

 

 

Clive Swan

 

 
I created a Transformer (ExtractDate).

 

 

Date is exported as a number:

 

ExtractDate

 

20140122000000.000

 

20140122000000.000

 

 

Cannot see where to disable the automatic detection??

 

 

 

 

 

 

 

 

Thanks,

 

 

Clive
"DD/MM/YY" is invalid as the Source Date Format. See the help on the DateFormatter, and specify the source format in correct syntax.

 

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/dateformatter.htm

 

 

Date Attributes: ExtractDate

 

Date Format:     (%d/%m/%Y)

 

Source Format: (%d/%m/%Y)   

 

 

Still exporting Native Oracle format (ExtractDate: 20140122000000.000)
If the source date format is "yyyymmddHHMMSS.xxx", FME can detect datetime automatically. Set "Unknown - Automatic Detection" to the Source Date Format parameter (but if you are using FME 2014 or earlier, you have to remove decimal places ".xxx" beforehand).
or be done with it and just use tcl clock functions ....and take control 😉 (i think fme uses that anyway, but tcl functions have a lareger scope)

Reply


Community Stats

30,108
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.