Elwyn Roberts

  • Total activity 35
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 5
  • Subscriptions 5


Recent activity by Elwyn Roberts Recent activity Votes
  • DataMeer TIMESTAMPDIFF Rounding issue?

    To calculate the number of seconds between two dates, I am using the TIMESTAMPDIFF function (only if there is a start datetime).IF(ISBLANK(#Start), 0, TIMESTAMPDIFF("SECOND", #Start, #End))For some...

  • Importing Excel Issue if some rows have null

    We have an excel file that we import.  One particular column sometimes does not have any values in it (so its null).  If the first x number of rows being imported are null, then the import "skips" ...

  • Extract values from a string

    We have a column for comments.  People can tag important info in this string field using a # and code for the Start date, end date, 3rd party system, Work effort in hours.  So a string value is inc...

  • ASDATE doesnt convert AM/PM correctly


    I have a column which holds the date but as a string.  Its in GMT so I need to convert it to EST as well.  The original date as string, looks like this:     14-SEP-19 PM Before I ca...

  • NonNumeric Characters


    I have pulled in a dataset which has the employee login which should be 6 numerics.  However, the data includes some nonnumeric characters (maybe contractors?) and so the column is STRING and not I...