<div>
In XL the value of any date value however it may be formatted is the same - an Integer.<br />
<br />
If you want as a literal text string you will need to adjust accordingly - ie format cell as Text and then apply your Format, eg:<br />
<br />
[code]<br />
With Range(cellRange)<br />
&nbsp; &nbsp; .NumberFormat = &quot;@&quot;<br />
&nbsp; &nbsp; .Value = Format(.Value,&quot;YYYY-MM-DD&quot;<wbr />)<br />
End With<br />
[/code]
</div>


In XL the value of any date value however it may be formatted is the same - an Integer.

If you want as a literal text string you will need to adjust accordingly - ie format cell as Text and then apply your Format, eg:

[code]
With Range(cellRange)
    .NumberFormat = "@"
    .Value = Format(.Value,"YYYY-MM-DD")
End With
[/code]

<div>
Should add - if you're using a UDF you should just use a standard cell function<br />
<br />
=TEXT(datecell,&quot;YYYY-MM-DD<wbr />&quot;)
</div>


Should add - if you're using a UDF you should just use a standard cell function

=TEXT(datecell,"YYYY-MM-DD")

<div>
<div class="content wysiwyg-content">
Hi. &nbsp;I need a fuction that will take any given date value and convert that date value into MySQL's &quot;YYYY-MM-DD&quot; format.<br />
<br />
I originally tried something like:<br />
<br />
Range(CellRange).Select<br />
Selection.NumberFormat = &quot;yyyy-mm-dd&quot;<br />
NoteDate = Worksheet.Range(CellRange)<wbr />.Value<br />
<br />
But apparently, that just changes its appearance, not its value.<br />
<br />

</div>
</div>


Hi.  I need a fuction that will take any given date value and convert that date value into MySQL's "YYYY-MM-DD" format.

I originally tried something like:

Range(CellRange).Select
Selection.NumberFormat = "yyyy-mm-dd"
NoteDate = Worksheet.Range(CellRange).Value

But apparently, that just changes its appearance, not its value.



Excel VBA Function To Convert Any Given Date to MySQL YYYY-MM-DD format?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.