Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Try using this Custom Format: </p> <pre><code>yyyy/mm/dd h:mm;@ </code></pre> <p>To enter it, right click on the cell and Choose Format Cell: </p> <p><img src="https://i.stack.imgur.com/SC3Ow.jpg" alt="Format Cell"></p> <p>Then under the <code>Number</code> Tab Select <code>Custom</code> from the listbox. And enter the provided format in the <code>Type:</code> textbox.</p> <p><img src="https://i.stack.imgur.com/fpY36.jpg" alt="Example"></p> <p>If that doesn't work. Are you *****Absolutely***** Positive that 04/06/2013 09:00:00 IS April 6, 2013 and NOT June 4, 2013?? </p> <p>If this still doesn't work and you have verified that dates are correct. </p> <pre><code>Sub ChangeDateFormat() Application.ScreenUpdating = False Dim CurrentCell As Range Dim LastRow As Long Dim RegEx As Object Set RegEx = CreateObject("vbscript.regexp") RegEx.Global = True LastRow = Range("A" &amp; Rows.Count).End(xlUp).Row 'Get The Last Row in Column Change A as Needed For Each CurrentCell In Range("A1:A" &amp; LastRow) ' Loop through all cells. Change Column as needed If InStr(CurrentCell.Value, "/") &lt;&gt; 0 Then 'To make sure only convert non converted ones RegEx.Pattern = "(\d{2})/(\d{2})/(\d{4}) (\d{2}):(\d{2}):(\d{2})" ' Seperate all parts of imported Data into groups CurrentCell.Value = RegEx.Replace(CurrentCell.Value, "$3.$2.$1 $4:$5") ' Change order of groups and place into cell. End If Next Application.ScreenUpdating = True End Sub </code></pre> <p>*****NOTE: ***** This will only work if <strong>ALL</strong> date values are of <code>dd/mm/yyyy hh:mm:ss</code> if they are not you will have to add some Error Handling and possibly slightly modify the code as it <strong><em>WILL</em></strong> cause problems. </p> <p>This will also work on dates that are inside of other text. If the value of <code>A1</code> is </p> <p><code>This is a test 04/06/2013 09:00:00 Lets see what happens</code> </p> <p>Then the new value will be</p> <p><code>This is a test 2013.06.04 09:00 Lets see what happens</code></p>
    singulars
    1. This table or related slice is empty.
    1. POFormatting time from dd/mm/yyyy hh:mm:ss to yyyy.mm.dd hh:mm
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USuser2140261
    1. USuser2140261
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POFormatting time from dd/mm/yyyy hh:mm:ss to yyyy.mm.dd hh:mm
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COCustom formatting the cells does nothing, I tried them myself too. I wrote a macro to format the cells, here: --- `LastRow = Range("I2").End(xlDown).Row; For i = 2 To LastRow; If Cells(i, 9).NumberFormat <> "yyyy.mm.dd hh:mm" Then; Ttime = Cells(i, 9).Value; Cells(i, 9).Value = Format(Ttime, "yyyy.mm.dd hh:mm"); End If; Next` --- I can't upload images right now, so here are two contradicting examples: Input -> result | 25/04/2013 10:00:00 -> 2013.04.25 10:00 | 01/04/2013 00:00:00 -> 2013.01.04 00:00
      singulars
      1. PO
      1. USAttila Boncok
    2. COIF you use `DATEVALUE` on the cell do you get `#VALUE!`?
      singulars
      1. PO
      1. USuser2140261
    3. COYes, same result with `TIMEVALUE`.
      singulars
      1. PO
      1. USAttila Boncok
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload