FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
Take a look at the available general examples, your question may already be answered here: Hello World 1 / 2 / 3 , format numbers as character strings , simple If-Then-Else , complex If-Then-ElseIf , filtering and grouping data , consolidate grouped values
  • Page:
  • 1

TOPIC: Date filed to text with format yyyy-MM-dd

Date filed to text with format yyyy-MM-dd 5 months 2 days ago #3501

  • Mark Krieger
  • Mark Krieger's Avatar Topic Author
  • Offline
  • Posts: 2
How do I get a date field to a string field with format yyyy-MM-dd 
Trying the date functions with append gets me dates like 2,018-5-6 - with a decimal separator (don't want to change the number formats) and single-digit dates for month and day. And just using a string field with the format yyyy-MM-dd gives just the original field.
Do I need to make a .NET heater for that or is there a built in way?

Thanks
Mark

Please Log in or Create an account to join the conversation.

Date filed to text with format yyyy-MM-dd 5 months 2 days ago #3502

Hi Mark,

The solution is quite simple. You just have to define your preferred dateformat in the Adapter settings on the WRITE side. -> General information about usage of Adapters

Attached you´ll find a short example how you can use different format setting in one definition. In your case, you have to switch the certain field DATATYPE to DATE and use the format setting like shown in the screenshot below, that’s all.

In the example, I used also the String Format Heater to demonstrate how youcan mix different formats in one definition.

Note: Because the first WRITE field “String (Adapter)” has no certain DATATYPE (only STRING), FlowHeater use the DATATYPE from the READ side field to format this column with the standard DATETIME format like the second column.



File Attachment:

File Name: datetime-s...rmat.zip
File Size:2 KB

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Attachments:

Please Log in or Create an account to join the conversation.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Date filed to text with format yyyy-MM-dd 5 months 2 days ago #3503

  • Mark Krieger
  • Mark Krieger's Avatar Topic Author
  • Offline
  • Posts: 2
Hi Robert

Wow. Just wow. Thank you so much. The attached file shows it nicely how to do it within the adapter or the format heater. Just the right thing for a beginner like me. And it's even easier than In thought.

Thank you
Mark

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2019 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en