Calculating new value of time using Now()

[Filistyn]

Hey!

I have a wrong default timezone, which can't be (sadly) changed. So if I use command Now() and for example collect my data into the SP list, the time in the SP list is 9 hours behind. Can I somehow calculate, that if I press a button and collect date, the Date column in my sharepoint list will have +9 hours? So it will be Collect(List, Date: Now() +9 hours).

Thanks for any help

[PG_WorXz10 · Accepted solution]

Hi @Filistyn ,

For adding hours to the date and time value you can use below formula. 

DateAdd(Today() or Now(),540,Minutes)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.