Question: I want to rename the text that says "Enter your address to view shipping options." in the WooCommerce checkout page right at the bottom where the "Your Order" section was located.

Here's the screenshot:

[![](https://i.stack.imgur.com/7wSEU.png)](https://i.stack.imgur.com/7wSEU.png)

Answer: 
if the dateTime is changing for you and your client, it means that there is an offset value attached to the dateTime when it is retrieved from the API.

So, do a check for development environment in your application and fetch the UTC DateTime using "UtcDateTime" property of DateTimeOffset type and display it in the UI so that it is the same for both you and your client. In case of the production environment, just keep the usual flowing going.

```
if(IsDevEnvironment)
   DateTimeToDisplay = ApiResponse.DateTimeInDB.UtcDateTime;  // assuming DateTimeInDB is of DateTimeOffset type
else
   DateTimeToDisplay = ApiResponse.DateTimeInDB

```
try that ;

```
HAVING        (Time BETWEEN DATEADD(d, - 1, GETUTCDATE()) AND GETUTCDATE())

```

it is helpful for me. 

example 

```
ELECT        Time, username, COUNT(username) AS CountOfusername
FROM            dbo.tabl
GROUP BY Time, username
HAVING        (Time BETWEEN DATEADD(d, - 1, GETUTCDATE()) AND GETUTCDATE())

```

edit

```
 DateTime hwTime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, "Arab Standard Time");
        //DateTime hwTime = new DateTime();
        try
        {
            TimeZoneInfo hwZone = TimeZoneInfo.FindSystemTimeZoneById("Arab Standard Time");
            Console.WriteLine("{0} {1} is {2} local time.",
                    hwTime,
                    hwZone.IsDaylightSavingTime(hwTime) ? hwZone.DaylightName : hwZone.StandardName,
                    TimeZoneInfo.ConvertTime(hwTime, hwZone, TimeZoneInfo.Local));
        }
        catch (TimeZoneNotFoundException)
        {
            Console.WriteLine("The registry does not define the Arab Standard Time zone.");
        }
        catch (InvalidTimeZoneException)
        {
            Console.WriteLine("Registry data on the Arab Standard Time zone has been corrupted.");
        }

```

us this code in your application