Skip to main content
Question

How to concatenate a date field (format: mm/dd/yyyy) and a time field (format: hh:mm:ss) to a single field (format: mm/dd/yyyyhh:mm:ss)? They are already transformed by two separate AttributeManager.

  • June 16, 2023
  • 3 replies
  • 108 views

3 replies

david_r
Celebrity
  • June 16, 2023

You can concatenate them as regular strings, e.g. in an AttributeManager:

@Value(my_date_attribute) @Value(my_time_attribute)

 

 


  • Author
  • June 16, 2023

Thank you for answering. they are not strings. the formats are date and time and will be translated to DateTime.


hkingsbury
Celebrity
Forum|alt.badge.img+67
  • Celebrity
  • June 18, 2023

Thank you for answering. they are not strings. the formats are date and time and will be translated to DateTime.

Thats fine, internally, FME treats datetimes as strings.

In fact datatypes really only exist when data is read/written - oversimplification, some more advanced use cases mean you need to change/specify data types within the process. In your case, datetimes in FME can just be treated as strings