Archives
It is very often that you need to get current date/time in your development. T-SQL To get today date without time as string variable use following script: Select CONVERT( CHAR(8), GetDate(), 112) To get datetime variable of today date without time use following script: Select CAST( CONVERT( CHAR(8), GetDate(), 112) AS DATETIME) VB System.DateTime.Now.ToString(“yyyyMMddhhmmss”) Now() […]
Problem:
Many business would not allow product shipped to a “PO Box” address. So would like to block any “PO Box” address being entered into any ship to address.
Solution:
1) Enter design mode of “Customer Ship Tos” Form.
2) We are going to first create a script. Go to “Menu -> Edit -> Script”, a Script window should open. Click “New”, enter Script Name called “NoPOBox”, then click OK.