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. Useful MySQL queries How to Calculate the Number of Days Between Two Dates How to: Extract a part of a delimited string. How to Force the Tez Framework for SmallJob Executions Comments 0 comments Please sign in to leave a comment.