Create DATE/TIME Stamp

[David_K]

Hi all,

I have a data table that provides date and times as separate fields.  Initially the date field was a string, but I have converted this to a date formatted field.

Can anyone advise how I can join the 2 fields together to get a single date/time stamp from which I can then hopefully work out NetWorkDays and time taken between 2 entries.

Thanks in Advance.

[Or]

You can concatenate your strings and use timestamp#(YourField,'FieldFormat')

[Chanty4u]

try this

   =Timestamp(Date#('Datefield','DD-MM-YYYY') + Time#('Timestampfield','hh:mm:ss'), 'DD-MM-YYYY hh:mm:ss')

[David_K]

Hi Chanty4u,

I have tried your script above in the 'Data load editor' but just get a blank result once I load the script.

Any ideas where I have gone wrong?

Thanks,

David_K

[Chanty4u]

have you given your correct date format  like below?  

=Timestamp(Date#('Datefield','YYYY-MM-DD') + Time#('Timestampfield','hh:mm:ss'), 'DD-MM-YYYY hh:mm:ss')

[David_K]

Hi Chanty4u,

Thanks for the additional guidance - it works OK now 

[Chanty4u · Accepted solution]

Great !  Please close this thread by accepting solution .so that it will helpful to others when they search on similar issue.