Search results
21 mar 2013 · In this case you can't just set a DATETIME to an empty string. Try it: SELECT CONVERT(DATETIME, ''); One workaround is to present your date as a string: CASE WHEN CONVERT(DATE, CreatedDate) = '1900-01-01' -- to account for accidental time THEN '' ELSE CONVERT(CHAR(10), CreatedDate, 120) + ' ' + CONVERT(CHAR(8), CreatedDate, 108) END
19 sty 2001 · But sometimes we try to push a blank value in the date column, which results in translating and inserting a 1900-01-01 00:00:00. The value 'Blank' (Single Quote with no value) is meant for data types which accept character data, but it is not recognized by the date or datetime data types.
17 lis 2015 · You can't get an empty string because you're returning the DATE value type from ISNULL. Per the docs, ISNULL. Returns the same type as check_expression. If a literal NULL is provided as check_expression, returns the datatype of the replacement_value.
30 sie 2016 · I am trying to copy a populated date in to a cell, but if that date cell is blank, I want to return a blank field. i.e. cell A1 is 31.07.16, cell A2 is blank. I want to create a formula that will pull the actual date of 31.07.16 and a blank field if A1 happens to be empty.
25 sty 2022 · Try Data > Get Data > From Other Sources > From Table/Range. Excel will probably convert the values to its own date/time format automatically. Alternatively, with such a value in D2 and down, enter the following formula in another cell in row 2, then fill down: =DATE(LEFT(A2,4),MID(A2,6,2),MID(A2,9,2))+TIMEVALUE(MID(A2,12,12))
The COUNTA and ISBLANK methods won't work if you want to handle these sorts of cells as blanks, since those two formulas look for truly empty cells. To handle formulas which output "", you have two options: If you always know the size of your range, you can use either of the following: =IF( COUNTBLANK(BM2:BQ2)=5, "", "Major Milestone Due")
5 sty 2013 · You need to force Excel to treat the contents of the cell as a text value instead of a number, which it does automatically with blank values. =A2 & "" This will force Excel into making that cell reference a text value, thus preventing the conversion of blanks into zeroes. Share. Improve this answer. edited Oct 30, 2015 at 23:38.
