AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Report De...
The expression cont...
 
Notifications
Clear all

Questions The expression contains a call of an undefined function DateAdd()

 
Acumatica Report Designer
Last Post by William Filipiak 4 years ago
2 Posts
2 Users
1 Reactions
1,626 Views
RSS
scotts
Posts: 2
 scotts
Topic starter
June 30, 2021 11:03 am
(@scotts)
Active Member
Joined: 5 years ago

I'm getting this error message in report designer on the following expression.  DateAdd is listed as an available function.

I currently have the expression in a variable, but I was also getting the error when I embed the DateAdd funtion in a larger expression.

(note: field names are part of a third party customization)

=DateAdd([FSSOEmployee.UsrIGAHWeekDay],'h', DateDiff('h', [FSSOEmployee.UsrIGAHWeekDay], [FSSOEmployee.UsrIGAHStartTime]))

Any ideas?  Am I missing something obvious?

Thanks

Scott

 


1 Reply
William Filipiak
Posts: 10
 William Filipiak
July 8, 2021 9:01 am
(@wfilipiak)
Eminent Member
Joined: 6 years ago

Scott, I have had to convert the "dates" in the function by using the CDate ()
Something like =DateAdd(CDate([FSSOEmployee.UsrIGAHWeekDay]),'h', DateDiff('h', CDate([FSSOEmployee.UsrIGAHWeekDay]), CDate([FSSOEmployee.UsrIGAHStartTime])))


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 25 Online
  • 2,411 Members
Our newest member: thollings
Latest Post: Generic inquiry with information from Audit history(CT301000)
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×