Null Date field

[Rodney Mills]

Hi there, I am using PRO version 6.2916. I have a MSACESS db. Our clients will not allow java script in their browsers. I am using magic cell (in a very basic way) to display info from thier database.

1) If the date is left blank (null) can a text message be displayed i.e. "When Requested"

2) or would it be better to pick a date gone by like 1/1/01 and use a (if date = 01/01/01 then display "when requested" ) type statement.

3) is this possible as field in database is date field (type mismatch)? in magic cell

4) can you use server side vbscript in magic cell.

Thankyou.

[Frank Kwong]

0. Your version is pretty old.. update and catch up.
1. Yes.
2. No need to, you can detect blank or Null and display text.
3. Yes, via latest version patch release.
4. No.

FK


------------
Rodney Mills at 8/4/01 9:11:25 PM

Hi there, I am using PRO version 6.2916. I have a MSACESS db. Our clients will not allow java script in their browsers. I am using magic cell (in a very basic way) to display info from thier database.

1) If the date is left blank (null) can a text message be displayed i.e. "When Requested"

2) or would it be better to pick a date gone by like 1/1/01 and use a (if date = 01/01/01 then display "when requested" ) type statement.

3) is this possible as field in database is date field (type mismatch)? in magic cell

4) can you use server side vbscript in magic cell.

Thankyou.