String to Date&Time

Hi all,

I couldnt manage to the string to date . Could yo pls help me? [string to date]
Thank you
(String to Date time)
KNIME_leadtimee.knwf (8.2 KB)

Hi @Aysedogan and welcome to KNIME Community Forum,

I just checked your workflow and it seems you have not included a sample data file. Could you provide a sample file or a few example date values here so we can see what the problem is?

:blush:

1 Like

ASAS20_Eski_KumaşKaynaklı.xlsx (1009.0 KB)
There are 2 types date, i couldnt both :slight_smile:

Since they are only date, you have to set the type to “Date”. There are 2 date formats so you can change one format to the other one or just use 2 String to Date&Time nodes. The latter is more straightforward here.

For “Sipariş Yerleştirme_MerchTarih” use this date format:
yyyyMMdd

For “Kumaş/İplik Alım Gerçekleşen Tarih” use this date format:
d.M.yyyy

:blush:

1 Like

thank you. I have another question related to time issue. I would like to subtract 10 days from the firts date. Then i would like to subtract the appended date from the second date.

I coudnt find the solition , I tried math formula but the dates didnt apperead in the menu
dates.knar.knwf (10.8 KB)

To work with date and time in KNIME you can use the nodes under “Other Data Types > Time Series” category. Nodes like Date&Time Shift and Date&Time Difference can be found there.

:blush:

it’s okey. Thank you so much :slightly_smiling_face:

2 Likes

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.