Convert Date to a string

[marathonlady]

How do I convert a date to a string?

Thanks in advance for any help.

 

[KenHigg]

Can you provide an example of how you intend to use it?

kh

 

[misscrf]

also please show us how your date data looks.

This will matter for how it is converted. I know there is a format thing if you look up in Access help convert date to string.

 

[marathonlady]

Convert date to string

Here's my problem: On a form I need to check if there is a date in a field. It is in the long date, with time, format. When I use the IsDate function, it always returns that there is a null even though there is a date. So I thought I would convert that date into a string, then check if anything is in the string, maybe with the Len function.

 

[KenHigg]

If you have a simple form, bound to a table and there is a date fld from the table, on the form, and you simply want to check and make sure the user places a value in it, the couldn't you just use if isnull ?

kh