GSA 5.2.11 Pro: Adding Date and time columns to new DateTime column?

[Björn Schaefer]

Hi all

Sounds like a simple thing, but I couldn't solve this yet:
a csv file is used as data source and this file contains to columns "Datum" and "Uhrzeit".

What I need is a Column "DatumUhrzeit" so I tried to create an new field by expression like this:

simply adding Datum and Uhrzeit doesn't work and some other expressions I've tried also failed like this i.e.

(Sheet1.Datum.ToString() + " " + Sheet1.Uhrzeit.ToString()).ToDate()


anyone with a helpfull hint?

 

[markvanderhurk]

Hi Björn,

You might try this:


Hope that helps!

Cheers, Mark

 

[Björn Schaefer]

Very tricky... but working as expected!

Thanks a lot!