AddHour resets the time to 00:00:00 before adding the hour.

AddHour resets the time to 00:00:00 before adding the hour.

Based on the documentation here:
https://www.zoho.com/deluge/help/functions/datetime/addhour.html

Here's my custom function:
  2. string ConvertDateFormat(string inputDate)
  3. {
  4. // Extract only the date-time part (before the timezone)
  5. dateTimePart = inputDate.subString(0,19);
  6. // Replace 'T' with a space to match "yyyy-MM-dd HH:mm:ss" format
  7. formattedDateTime = dateTimePart.replaceAll("T"," ");
  8. // Convert to a Deluge date-time object without losing the time
  9. parsedDateTime = formattedDateTime.toDate("yyyy-MM-dd HH:mm:ss");
  10. // Add 1 hour
  11. adjustedDateTime = parsedDateTime.addHour(1);
  12. // Format back to "yyyy-MM-dd HH:mm:ss"
  13. finalFormattedDate = adjustedDateTime.toString("yyyy-MM-dd HH:mm:ss");
  14. return finalFormattedDate;
  15. }
Input is this:
  2. {
  3. "inputDate": "2025-04-30T11:30:00+10:00Z"
  4. }
But output looks like this:
  1. {
    "followUpDate_4": "2025-04-30 01:00:00"
  2. }

Expected output should be 12:30 PM instead of 01:00 AM