author: @kawam tags:#kissflow


You can convert the UTC time returned by the Now() function to your local time zone using a formula. For example, if you are in a time zone that is 5 hours ahead of UTC, you can add 5 hours to the Now() function to get the current date and time in your local time zone: Now() + (5/24). If you are in a time zone that is behind UTC, you can subtract the number of hours from Now().

The 5/24 represents the number of hours you want to add or subtract from the UTC time returned by the Now() function. In this example, 5 represents the number of hours ahead of UTC your time zone is. Dividing by 24 converts the number of hours to a fraction of a day since date and time values in Kissflow are stored as fractions of a day. For example, 6:00 AM is stored as 0.25 because it is one-quarter of a day.

So if you want to add 5 hours to the UTC time returned by Now(), you would use Now() + (5/24).