# Want to combine data and time input

**URL:** <https://forum.inductiveautomation.com/t/want-to-combine-data-and-time-input/53833>\
**Category:** Ignition\
**Tags:** ignition80, scripting, perspective\
**Created:** [December 7, 2021, 12:54pm UTC](https://forum.inductiveautomation.com/t/want-to-combine-data-and-time-input/53833 "2021-12-07T12:54:46Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ajaykumar\_Unhale](https://avatars.discourse-cdn.com/v4/letter/a/6a8cbe/32.png) [@Ajaykumar\_Unhale](https://forum.inductiveautomation.com/u/Ajaykumar_Unhale)\
**Post date:** [December 7, 2021, 12:54pm UTC](https://forum.inductiveautomation.com/t/want-to-combine-data-and-time-input/53833/1 "2021-12-07T12:54:47Z")

</div>

Hello  
I use two DateTimeInput component’s. 1 shows only date and 2 shows time only.  
I want to combine data and time and show this on label.  
I do this but return type is a string not a date and time  
concat(dateFormat({…/DateTimeInput.props.formattedValue},“YYYY-MM-dd”),dateFormat({…/DateTimeInput\_0.props.formattedValue}," HH:mm"))

I also use  
toDate(concat(dateFormat({…/DateTimeInput.props.formattedValue},“YYYY-MM-dd”),dateFormat({…/DateTimeInput\_0.props.formattedValue}," HH:mm")))  
but shows error

so can we return the date time parameter after combining two datetime components  
with this I am attaching image  
 ![date_Time](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/5/656d3e7aa8bdd4c26a41f86ac6fad993290756e5.png)

thank you

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [December 7, 2021, 1:27pm UTC](https://forum.inductiveautomation.com/t/want-to-combine-data-and-time-input/53833/2 "2021-12-07T13:27:51Z")

</div>

> [@Ajaykumar\_Unhale](#):
>
> toDate(concat(dateFormat({…/DateTimeInput.props.formattedValue},“YYYY-MM-dd”),dateFormat({…/DateTimeInput\_0.props.formattedValue}," HH:mm")))  
> but shows error

`toDate(concat(dateFormat({../DateTimeInput.props.value},"YYYY-MM-dd"),dateFormat({../DateTimeInput_0.props.value}," HH:mm:ss")))`  
will get a date type  
you can then (if you dont want the seconds) do a format to string again for the label  
`dateFormat({../DateTimeInput_1.props.value},'YYYY-MM-dd HH:mm')`

---

<div class="post-metadata">

**Author:** ![Ajaykumar\_Unhale](https://avatars.discourse-cdn.com/v4/letter/a/6a8cbe/32.png) [@Ajaykumar\_Unhale](https://forum.inductiveautomation.com/u/Ajaykumar_Unhale)\
**Post date:** [December 7, 2021, 2:22pm UTC](https://forum.inductiveautomation.com/t/want-to-combine-data-and-time-input/53833/3 "2021-12-07T14:22:36Z")

</div>

> [@victordcq](#):
>
> toDate(concat(dateFormat({../DateTimeInput.props.value},"YYYY-MM-dd"),dateFormat({../DateTimeInput\_0.props.value}," HH:mm:ss")))

Hello tested but following error occur please check image  
 ![date_Time1](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/3/d3d5ac4d6756b8c46f7de8386cc7312e4fa656db.png)

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [December 7, 2021, 2:38pm UTC](https://forum.inductiveautomation.com/t/want-to-combine-data-and-time-input/53833/4 "2021-12-07T14:38:14Z")

</div>

its working for me

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/c/4c81354bf7cc5007172db56dabb6ac39150d183f.png)

---

<div class="post-metadata">

**Author:** ![Ajaykumar\_Unhale](https://avatars.discourse-cdn.com/v4/letter/a/6a8cbe/32.png) [@Ajaykumar\_Unhale](https://forum.inductiveautomation.com/u/Ajaykumar_Unhale)\
**Post date:** [December 7, 2021, 5:36pm UTC](https://forum.inductiveautomation.com/t/want-to-combine-data-and-time-input/53833/5 "2021-12-07T17:36:04Z")

</div>

Hello  
Please can you tell me the return type .is it string or datetime?

---

<div class="post-metadata">

**Author:** ![Ajaykumar\_Unhale](https://avatars.discourse-cdn.com/v4/letter/a/6a8cbe/32.png) [@Ajaykumar\_Unhale](https://forum.inductiveautomation.com/u/Ajaykumar_Unhale)\
**Post date:** [December 8, 2021, 7:29am UTC](https://forum.inductiveautomation.com/t/want-to-combine-data-and-time-input/53833/6 "2021-12-08T07:29:52Z")

</div>

> [@victordcq](#):
>
> toDate(concat(dateFormat({…/DateTimeInput.props.value},“YYYY-MM-dd”),dateFormat({…/DateTimeInput\_0.props.value}," HH:mm:ss")))

Hello Victordcq  
Thank you very much it works

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [December 8, 2021, 7:36am UTC](https://forum.inductiveautomation.com/t/want-to-combine-data-and-time-input/53833/7 "2021-12-08T07:36:46Z")

</div>

> [@victordcq](#):
>
> will get a date type

i said it was date(time) type

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [December 8, 2021, 7:37am UTC](https://forum.inductiveautomation.com/t/want-to-combine-data-and-time-input/53833/8 "2021-12-08T07:37:09Z")

</div>

Ah good that it works, please mark the solution^^