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.

  • Jun 16, 2023 5:10 PM UTC
  • 3 replies
  • 167 views

3 replies

david_r
Celebrity
  • Jun 16, 2023 8:11 PM UTC

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

@Value(my_date_attribute) @Value(my_time_attribute)

 

 


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+73
  • Celebrity
  • Jun 18, 2023 10:34 PM UTC

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