eMihl's questions

I have a data source with a "timestamp" column that reflects the time as follows:

2022-08-17T19:20:41.218+0200

My question is if there is any direct way, that does not need a loop that goes through all the files (there are tens of thousands a day), to transform that date format into a more friendly one of the style:

2022-08-17 19:20

I have tried the following, among other things, with no positive results:

Rango.Columns("F").NumberFormat = "mm/dd/yyyy HH:mm"

Rango.Columns("F").NumberFormat = "mm/dd/yyyy hh:nn"

Thanks for the help.

I have been trying for several days to figure out how to assign a value to a specific cell using VBA, but instead of using the excel coordinates (B4, D9..) or (5.6 - 6.9 - etc.), I use the name of the row and column, that is, use the first row as header, and the first column as index, to be able to dynamically locate the cells that interest me, since they will not always be located at the same coordinates.

That is, instead of doing this:

Range(Cells(4, 5), Cells(8, 9))
Range("C4")
Cells(4, 6).Value = variable_x

Being able to do something like this:

Cells("ID374839", "SALARIO")

Where ID374839 would be the row ID, and "SALARY" the column header.

Thank you very much in advance.

I have created a coroutine inside a function to achieve, through the withContext, that the thread waits for the result of the get() launched to firestore. However, it seems that the get() method creates a separate thread, so I can't get the coroutine to wait for the variables to be assigned their corresponding values. The execution continues, and the variables are left with their default values, not with the values ​​collected in firestore.

How should I use the coroutine so that it expects the result requested from the firestore via the get() method? Is there an alternative way to do what I want?

GlobalScope.launch(Dispatchers.Main) {

      val recyclerView: RecyclerView = view.findViewById(R.id.recycler1)
      recyclerView.layoutManager = LinearLayoutManager(context)

      val database = FirebaseFirestore.getInstance()

      withContext(Dispatchers.IO) {
         database.collection("grupos").document("2").get().addOnSuccessListener {
           nombreEvent = it.getString("name")
           artista = it.getString("artista")
           descripcion = it.getString("descripcion")
           lugar = it.getString("lugar")
           imagen = it.getString("imagen")
         }
       }

       val adapterRec = RecyclerAdapter( listOf(Grupo("id", nombreEvent, artista, descripcion, lugar,imagen)))
       recyclerView.adapter = adapterRec
            
}