A mid function and a format (access 2000)

Topic

New Reply

What is wrong with this – TransactionDate: format([Mid$([FullLineField],25,6)], yy/mm/dd)
I get an error
or how can I change a text to date
show me some examples

Reply | Quote

Replies

Not that I would want to move the dd to the end of the format, but try the ” ” around the yy/mm/dd. See if that does it.
Paul
TransactionDate: format([Mid$([FullLineField],25,6)], “yy/mm/dd”)

Reply | Quote

Try this:

format([Mid$([FullLineField],25,6), “yy/mm/dd”)

You had an extra ] in there, and you need quotes around the date format.

Reply | Quote

I would tend to use the cdate() function rather than the format() function (although the format function does work)

Just as an alternative really I guess

cdate(Mid$([FullLineField],25,6))

Cheers

Jayden

Reply | Quote