Hi All - Hopefully a really easy one. How do I get the EOMONTH function to work as a calculated field in a BAQ? I feel like I have used a many times before but im getting a syntax error on it.
EOMONTH(UD38.Date01,1)
You might just need to convert UD38.Date01 to a date, its probably DateTime.
EOMONTH( CAST(UD38.Date01 as date), 1)
1 Like
And maybe test for NULL too?
BTW - According to some Help file of the E10.2.300 schema somebody created, its a Date filed…
1 Like
Also what type of errors. It should work, which is odd.
I think that’s prob it.
Is the calc field set up as a Date?
Nulls don’t seem to be an issue.
I have UD table and set the Date01 value of just one record, and it has no issues.
1 Like
SOME times I have used a reserved word for the calculated field name and that threw an error that had nothing to do with the formula. Just a check point…
2 Likes
Yep dont call your Calculated Field EOMONTH… Count always gets me 
2 Likes
MS SQL version?
Thanks for the help guys. @Mark_Wonsil I called the calculated field EOMONTH… Works fine with the new name. Appreciate the help.
1 Like