Date formatting

[sborny]

Hi,

I have an app that pulls data from a database which I can do no problem.

One of the fields contains a date in plain format

ie 250772 (25th July 1972)

Please note that these are english format for dates.

I need my app to pull this data and conver it to the following format.

25-JUL-1972

I have looked at the date function and the format function but cannot seem to get it to work.

Any ideas.

Cheers

S.


Everything has an answer, it's just knowing the right question to ask. !!!!

 

[gwar2k1]

dd & "-" & mmm & "-" & yyyy

not sure though, youre best waiting for some1 else to reply

~*Gwar3k1*~
"To the pressure, everything's just like: an illusion. I'll be losing you before long..."

 

[johnwm]

There are many approaches to this. The simple way might be:
Convert number to string, using Cstr()
Add / as date separators, using Left$(), Mid$() and Right$() first to split into 3, recombining with '&'
Convert to proper date using Format using "dd-mmm-yy" format string

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[LostInCode]

Simpler:

Format$(Format$("250772","##-##-##&quot,"dd-mmm-yyyy&quot

Assuming the date string is always 6 digits, and the system is set in the same format (dd-mm-yyyy, meaning day/month, and not month/day)