nevodj Posted September 13, 2011 Share Posted September 13, 2011 Hello just wondering if this can be done. I'm querying an SQL database to get monthly figures. This is going to be hard to explain... sorry if it's not clear! Here's some simplified code to give you some idea. $CurrentMonthLastYearDateBegin = @YEAR - 1 & "-" & @MON & "-" & "01"$CurrentMonthLastYearDateEnd_Full = @YEAR - 1 & "-" & @MON & "-" & "30"SELECT TOTAL FROM TABLE WHERE DATE >= $CurrentMonthDateBegin AND DATE <= $CurrentMonthDateEnd_Full I can't set this:$CurrentMonthLastYearDateEnd_Full = @YEAR - 1 & "-" & @MON & "-" & "30" to 31 because if it's a 30 day month the SQL returns an error: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. So i need a variable that is equal to the amount of days in the current month. Appreciate any help. Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted September 13, 2011 Moderators Share Posted September 13, 2011 nevodj,Perhaps the _DateDaysInMonth function might help? M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area Link to comment Share on other sites More sharing options...
ReFran Posted September 13, 2011 Share Posted September 13, 2011 or SELECT TOTAL FROM TABLE WHERE DATE like @YEAR - 1 & "-" & @MON & "%" Link to comment Share on other sites More sharing options...
nevodj Posted September 13, 2011 Author Share Posted September 13, 2011 Thanks Link to comment Share on other sites More sharing options...
nevodj Posted September 14, 2011 Author Share Posted September 14, 2011 BTW ReFran yours doesnt work. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now