Date stamp

[#1]

Hello,

In the source data is a date stamp given like: 3/8/2016 8:00:00 AM

This has to be transform to only the date 08-03-2016 so I can use it in a chart.

Caution by a date 3/16/2016 is an extra character.

The transformation has to be done in the script.

Can you help me with the script?

Thanks in advance.

Ralph

[#2]

it works for one database but I get every week a database with a new date. So I can create a trend.

I drop them into a map and load them with "databasenaam *".

When I load all the databases it doesn't work anymore. I don't get it.

I attached a few databases.

Can you pls help me again.

I'm sorry for the miscommunication.

[sunny_talwar · Accepted solution]

I don't know what the difference is between the dates, they all look the same. See the attached

Script:

Data:

LOAD [Technical Designation],

  [User Designation],

  [System Description],

  Parameter,

  Value,

  Unit,

  Status,

  [Value Timestamp],

  Date(Floor(TimeStamp#([Value Timestamp], 'M/D/YYYY h:mm TT')), 'DD-MM-YYYY') as [Value Date]

FROM

Database*.xls

(biff, embedded labels, header is 19 lines, table is [Installatie Status PX Tapwater$]);

[#4]

Thank you again!

[sunny_talwar]

No problem my friend