web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Unhandled Script Excep...

Microsoft Dynamics GP (Archived)

Unhandled Script Exception Invalid 29 in date function

(0) Share

Report

Report

Posted on by Brenda Willey

2,520

When running a payroll calculate we are getting the following error....

Unhandled Script Exception:

Invalid date '29 in date function. script terminated

This Payroll is for a date range that includes 2/29/2016.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

WindyCityGP 1,069 on at

Like (1)

Report
Copy link

Link copied!

I received this same error today. I went into the Control Panel>>Region and Language and changed the "Short Date" format to MM/DD/YYYY on that workstation experiencing the error. We removed the build and logged out/back into GP. We ran the build again, and did not receive the error. So far, no other workstations have had this issue, but they will be doing more payroll next week that may cross the 2/29 date.

Hope this helps!

Was this reply helpful? Yes No
WindyCityGP 1,069 on at

Like (3)

Report
Copy link

Link copied!

I talked to Microsoft yesterday and it is a known issue. As a work around, they suggested changing the date for anyone with a start date of 2/29/xxxx to a day before or after. Didn't sound as though there would be a service pack anytime soon since the conditions only occur every 4 years.

Was this reply helpful? Yes No
Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

wow, nice information share.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans