Azure function - Powershell Date.AddDays not working

Question

Azure function - Powershell Date.AddDays not working

Madhu Rao 120

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,085 Reputation points Microsoft External Staff 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.

Your answer

Praveen Kumar Gudipudi 1,085 Reputation points Microsoft External Staff 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.

Share via

Azure function - Powershell Date.AddDays not working

Your answer