Azure function - Powershell Date.AddDays not working

Question

Azure function - Powershell Date.AddDays not working

Madhu Rao 160

Hi,

I have an Azure function that uses a date span to run a query. I am using the existing date and a (-ve) numeric value.

The below script works on my laptop.

$cldopsemailqrystrtdays = -7  # Set this to how many days back you want to go
$endtime = (Get-Date).Date    # Midnight today
$starttime = $endtime.AddDays($cldopsemailqrystrtdays)
Write-Output "Start Time: $starttime"
Write-Output "End Time:   $endtime"

I am passing an env: variable in Azure Function to pass on a numerical value that would be the start date of my query. The Azure function fails to recognise the start date.

$cldopsemailqrystrtdays=$env:cldopsemailqrystrtdays

$endtime = (Get-Date).Date
$starttime = ($endtime).AddDays($cldopsemailqrystrtdays)

$starttimemsg = $starttime
$endtimemsg = $endtime

Write-Host "$starttime - $endtime"

Thanks in advance.

Praveen Kumar Gudipudi 1,880 Reputation points Moderator

2025-06-13T06:19:34.55+00:00
Hello Madhu Rao,

Thanks for reaching out.

The issue is likely because the environment variable $env:cldopsemailqrystrtdays is treated as a string in Azure Functions, but .AddDays() needs a number.

To fix this, you can convert the value to an integer before using it, like this:

[int]$cldopsemailqrystrtdays = $env:cldopsemailqrystrtdays

This ensures the AddDays() method works properly.

Please check above suggested method and let us know with an update.
Madhu Rao 160 Reputation points

2025-06-16T05:42:28.8066667+00:00

Thanks, it worked.

Answer accepted by question author

0 additional answers

Your answer

Praveen Kumar Gudipudi 1,880 Reputation points Moderator

2025-06-13T06:19:34.55+00:00

Hello Madhu Rao,

Thanks for reaching out.

The issue is likely because the environment variable $env:cldopsemailqrystrtdays is treated as a string in Azure Functions, but .AddDays() needs a number.

To fix this, you can convert the value to an integer before using it, like this:

[int]$cldopsemailqrystrtdays = $env:cldopsemailqrystrtdays

This ensures the AddDays() method works properly.

Please check above suggested method and let us know with an update.
Madhu Rao 160 Reputation points

2025-06-16T05:42:28.8066667+00:00

Thanks, it worked.

Answer 1

Hi @Madhu Rao ,

Initially I have environment variable as below:

Then used blow code that works:

using namespace System.Net

param($Request, $TriggerMetadata)
Write-Host "Hello Rithwik"
$cldopsemailqrystrtdays = $env:cldopsemailqrystrtdays -as [int]
$endtime = (Get-Date).Date
$starttime = $endtime.AddDays($cldopsemailqrystrtdays)
Write-Host "Rithwik, the Start Time is $starttime"
Write-Host "Rithwik, the End Time is   $endtime"
$rithout = @{
    startTime = $starttime.ToString("yyyy-MM-ddTHH:mm:ssZ")
    endTime   = $endtime.ToString("yyyy-MM-ddTHH:mm:ssZ")
}
Push-OutputBinding -Name Response -Value ([HttpResponseContext]@{
    StatusCode = [HttpStatusCode]::OK
    Body = $rithout | ConvertTo-Json -Depth 3
})

Output:

enter image description here

You can also use below code, which gives expected results:

$cldopsemailqrystrtdaysRaw = $env:cldopsemailqrystrtdays
$cldopsemailqrystrtdays = [int]$cldopsemailqrystrtdaysRaw

If this answer was helpful, please click "Accept the answer" and mark Yes, as this can help other community members.

enter image description here

If you have any other questions or are still experiencing issues, feel free to ask in the "comments" section, and I'd be happy to help.

Madhu Rao 160 Reputation points

2025-06-16T05:43:14.3166667+00:00

Thanks.

Share via

Azure function - Powershell Date.AddDays not working

0 additional answers

Your answer