How to Extract the Calendar Week From a Date-Input Field Gido September 01, 2016 11:23 Updated Follow Goal Learn how to extract the calendar week from a date-input field. Learn Use the function FORMATDATE and provide a lower case w for the parse patterns. Using this function gives you as result the week of year. Related articles How to enable Jetty request logging to find out what IP an HTTP request is coming from. How to: Extract a part of a delimited string. Useful MySQL queries How to Calculate the Number of Days Between Two Dates Task attempt fails with Container released on a *lost* node Comments 0 comments Please sign in to leave a comment.