Assuming format is required, the following 101 results were found.
-
which caused even more errors (had to return the pen for another and another) as well as the common USB disk storage format tools for Windows. Note that any data on the USB pen is automatically lost, and that if you use rescue programs, you may corrupt...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
MONTHNAME(now()) DATENAME(mm, getdate()) Month Number MONTH(now()) DATEPART(mm, getdate()) European Date (dd/mm/yyyy) DATE_FORMAT(now(), '%d/%m/%Y') CONVERT(varchar, getdate(), 103) Time to Seconds TIME_TO_SEC(now()) (DATEPART(hour, getdate()) * 3600) +...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
@DateVal date; DECLARE @TimeVal time; DECLARE @DateMatch int; DECLARE @TimeMatch int; DECLARE @ColumnTypeIsDate int; -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); -- Set variable default values SET @NewVal =...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
int; DECLARE @TimeMatch int; DECLARE @ColumnTypeIsDate int; DECLARE @IntOptions int; DECLARE @CharOptions varchar(max); -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); -- Set variable default values SET...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
done or not) Submit all marketing, promotional material (can include fonts, images, word documents, etc) We can accept most formats except for those exclusive to the Apple Mac operating systems. Webspace Setup For JoelLipman.Com to do: Assess allocated...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
so until I do some benchmarking I won't know which ones best: Method #1 This method replicates the table in a listview format: ; tell the script which content to parse Haystack := CodeContainingMyHTMLTable ; determine markers (character positions)...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
loop through all rows of the above mysql query Count for each row how many times the column1.table1 value appears in table1 Format this count result by prefixing with leading zeros (for sorting purposes - eg. so 10 is not before 2) Store both the...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
but this one I understand and can customize to fit my needs. This PHP function accepts as parameter a SQL date (or date format that strtotime() can convert) and outputs the largest unit (for example "1 year" not "1 year 2 months 3 days, etc...")....
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
anyAttribute Enables the author to extend the XML document with attributes not specified by the schema appinfo Specifies information to be used by the application (must go inside annotation) attribute Defines an attribute attributeGroup Defines an...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: en-GB
-
and there but none of them produced consistent results. One solution was to untick "Simplify page headers" on the Excel Format Options when you export the report. Because our report is exported via a web-based system, this extra dialog doesn't appear...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
refreshing data and preferred the end result with this change. Note on "row height": We did not want the customer having to format the report after they've already gone through the hassle of clicking on the big fat refresh button... Keeping It Simple...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
a single spreadsheet into multiple worksheets of 3000 rows each, and then output each sheet to a separate file that is formatted as XLS (Not *.xlsx). How? In summary, we are going to move the Excel file to a folder of its own. We're going to run two...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Settings. Click on the Devices heading to show the Device Summary Under Device Summary, you will be shown a host of information related to your device, which includes the email address associated to your Kindle. Copy and save the email at your desired...
- Type: Article
- Author: Joel Lipman
- Category: Kindle
- Language: *
-
ZohoCRM or ZohoCreator. Why? You may have received an error that goes something like: datatype: datetime How? Here are some formatting examples: Creator to CRM: v_CreatorTime = zoho.currenttime.toTime(); v_CrmTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
this was actually specified in the report. Here's a quick note on how to set Dates and Times used in parameter fields to UK format (dd/MM/yyyy). You can override this in the report by: Go to Design Select the View tab Check that the "Properties" pane is...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
a note because I spent time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells have a border and non-empty don't). This was so that a grid would show for empty spaces. I wasn't...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Problem I've set some tablix headers but when I request the same report in PDF format, the tablix headers only appear once on the first page. Every subsequent page simply displays the report header (which does not include the tablix header......
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
to display if there is no date to populate the field. Why? At the moment, the expression in there is something like this: =Format(Fields!MyCompletionTime.Value, "dd/MM/yyyy HH:mm:ss") -- yields 11/02/2014 11:21:32 Sounds good, where's the problem? The...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
-- 2012-04-28 11:00:00 -- is a Saturday -- 2012-04-29 12:00:00 -- is a Sunday DATE_ADD( givenDate, INTERVAL ( 6 - DATE_FORMAT( DATE_ADD(givenDate, INTERVAL 1 DAY), \'%w\' ) ) DAY ) AS WeDate -- OR -- DATE_ADD( givenDate, INTERVAL ( 7 - DAYOFWEEK(...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
tip or note to self: How to get yesterday's date irrespective of date format or daylight savings time. $today=date("Y-m-d"); $yesterday = date('Y-m-d', mktime(0, 0, 0, date("m") , date("d") - 1, date("Y")));
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB