topic Re: How to add 60 minutes to a modifieddate(columnname) datetime(columntype) using expression builder in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009639#M11696 <P>You can try below.</P> <P>&nbsp;</P> <P>[Your Field Name] + time#(60,'h')</P> Mon, 28 Nov 2022 10:19:56 GMT kaushiknsolanki 2022-11-28T10:19:56Z How to add 60 minutes to a modifieddate(columnname) datetime(columntype) using expression builder https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009595#M11694 <P>I have a column called modifieddate with datetime type . now i need to add 60 minutes for that column using expression builder.</P> Mon, 28 Nov 2022 09:22:07 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009595#M11694 GuruLatha 2022-11-28T09:22:07Z Re: How to add 60 minutes to a modifieddate(columnname) datetime(columntype) using expression builder https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009639#M11696 <P>You can try below.</P> <P>&nbsp;</P> <P>[Your Field Name] + time#(60,'h')</P> Mon, 28 Nov 2022 10:19:56 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009639#M11696 kaushiknsolanki 2022-11-28T10:19:56Z Re: How to add 60 minutes to a modifieddate(columnname) datetime(columntype) using expression builder https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009643#M11697 <P>When trying like above i am getting below error</P> <P>&nbsp;</P> <P>Failed to init column calculation expression '[ModifiedDate] + time#(60,'h')'<BR />SQLite general error. Code &lt;1&gt;, Message &lt;unrecognized token: "#"&gt;.</P> Mon, 28 Nov 2022 10:23:21 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009643#M11697 GuruLatha 2022-11-28T10:23:21Z Re: How to add 60 minutes to a modifieddate(columnname) datetime(columntype) using expression builder https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009646#M11698 <P>Are you trying this in SQL Select statement or in Load Statement?</P> Mon, 28 Nov 2022 10:24:40 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009646#M11698 kaushiknsolanki 2022-11-28T10:24:40Z Re: How to add 60 minutes to a modifieddate(columnname) datetime(columntype) using expression builder https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009653#M11699 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Date.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/94729iA667C3FF6FF42628/image-size/large?v=v2&amp;px=999" role="button" title="Date.PNG" alt="Date.PNG" /></span></P> Mon, 28 Nov 2022 10:27:06 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009653#M11699 GuruLatha 2022-11-28T10:27:06Z Re: How to add 60 minutes to a modifieddate(columnname) datetime(columntype) using expression builder https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009655#M11700 <P>Ohh It seems you are trying this in Compose or in Replicate right?</P> Mon, 28 Nov 2022 10:28:17 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009655#M11700 kaushiknsolanki 2022-11-28T10:28:17Z Re: How to add 60 minutes to a modifieddate(columnname) datetime(columntype) using expression builder https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009658#M11701 <P>I am trying in Qlik Replicate</P> Mon, 28 Nov 2022 10:29:54 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009658#M11701 GuruLatha 2022-11-28T10:29:54Z Re: How to add 60 minutes to a modifieddate(columnname) datetime(columntype) using expression builder https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009660#M11702 <P>OK. I need to check in Replicate. Will try and get back to you.</P> Mon, 28 Nov 2022 10:30:56 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009660#M11702 kaushiknsolanki 2022-11-28T10:30:56Z Re: How to add 60 minutes to a modifieddate(columnname) datetime(columntype) using expression builder https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009664#M11703 <P>When i am giving like below it goes like this -&nbsp;0000-00-00 00:00:00.000</P> <P>&nbsp;</P> <P>datetime('now','+60 minutes','localtime')</P> Mon, 28 Nov 2022 10:48:31 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-add-60-minutes-to-a-modifieddate-columnname-datetime/m-p/2009664#M11703 GuruLatha 2022-11-28T10:48:31Z