Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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$]);
Thank you again!
No problem my friend