How to add 60 minutes to a modifieddate(columnname) datetime(columntype) using expression builder

[GuruLatha]

I have a column called modifieddate with datetime type . now i need to add 60 minutes for that column using expression builder.

[kaushiknsolanki]

You can try below.

[Your Field Name] + time#(60,'h')

[GuruLatha]

When trying like above i am getting below error

Failed to init column calculation expression '[ModifiedDate] + time#(60,'h')'
SQLite general error. Code <1>, Message <unrecognized token: "#">.

[kaushiknsolanki]

Are you trying this in SQL Select statement or in Load Statement?

[GuruLatha]

[kaushiknsolanki]

Ohh It seems you are trying this in Compose or in Replicate right?

[GuruLatha]

I am trying in Qlik Replicate

[kaushiknsolanki]

OK. I need to check in Replicate. Will try and get back to you.

[GuruLatha]

When i am giving like below it goes like this - 0000-00-00 00:00:00.000

datetime('now','+60 minutes','localtime')