Add days to datetime and replace time with custom time

[jwalantdvyas]

I want to add 2 days to my date and time field and replace time with custom value

if my

[datetime] = 2022-03-21 10:00

I want to add 2 days to it and change time to 13:00

[OutDateTime] = 2022-03-23 13:00

[AkimasaKajitani]

Hi @jwalantdvyas 

You can use DateTimeTrim expression to cutoff the hours and use the DateTimeAdd expression to add 61(24*2+13) hours.

DateTimeAdd(DateTimeTrim([datetime],"day"),61,"hour")

[Qiu]

@jwalantdvyas 
Since " 2022-03-21 10:00" is not a standard Date Time format, I am afraid we need to some parsing first.