Re: Format conversion from number to YYYYMM

piotr.kabath@xxxxxxxxx wrote in news:57afa132-6a92-4211-b227-4edd8079961a@
34g2000hsz.googlegroups.com:

Hi I have date stored as number in yyyymm format, as I need to
calculate previous month\ prev 3 months etc, I need to convert this to
date format yyyymm.
I have tried but with no success, I would be thankful for help.

Debug.Print CDate(Format(200802, "####-##"))

2008-02-01

--
lyle fairfield

In ancient times Ulysses had to outwit the sirens, who had the power to
charm by their song all sailors who heard them, so that the mariners were
compelled to cast themselves into the sea to their destruction.
Today, he would have to deal with (free) Aim-Mail.





.

Relevant Pages