Search results

Here's something I'm hoping someone will be able to help me with; I have a form based on a table populated from one of our servers. This leaves some fields blank, which is fine. What I need is to have 2 of the blank fields mandatory, but ONLY if certain other fields have any values entered...

I'm trying to change a standard date value into the date format used by our AS400 system (this is year - 1900 & mm & dd e.g. 1st Jan this year = 1060101). I'm using 'Datepart' but I'm running into a couple of problems; Datepart doesn't give leading zeros, that I need & mid seems to do the same...