Category Archives: Date

No Thumbnail

VBA Converting Data Types

In this article I will explain how you can convert data types to one another. Jump To : String Conversions Convert String to a Numeric Data Type Check if String is Numeric, IsNumeric() Convert String to Integer, CInt() Convert String to Double, CDbl() Convert String to

No Thumbnail

Query Dates Type Mismatch Error, Access

Previously in the article Query Dates, Access I’ve explained how you can run queries on date values.  However if double quotes are used in the  criterion section a type mismatch error will occur. In the figure below you can see a query in design mode: This is the

No Thumbnail

Word VBA, Date Format

When writing dates to a word document you could specify a specific format. For example consider the code below: Sub main() Range.Text = Date End Sub It prints the current date to the document: We can change the way the date is output using the code

No Thumbnail

Excel, Custom Formatting, Month Language

If you’ve worked with dates in Excel there may be times you want to display dates in a language other than english. For example lets say you want to display the following date in german: German equivalent: As previously explained in the article below you have 2 different

No Thumbnail

Excel, Dates

When working in Excel there are going to be times where you need to specify a date value. There are different methods for specifying a date in Excel. This article briefly explains them and provides links to more detailed explanations. Before explaining the different methods

No Thumbnail

VBA Excel String Processing and Manipulation

When you are working with strings, string processing and manipulation is an important tool. Whether you want to search for a certain expression in a string, split a string, add multiple strings … you will have to be familiar with the concepts of string processing.