Csv upload timestamp format

[#1]

Hello guys,

i have a already built qilkview dashboard. I just need to upload some additional data (extra rows). The timestamps loaded previously was in this format "15/05/2015 00:00:00". the csv cell format was in GENERAL format.

the new data that I have to add has the timestamp in the following format "28/04/2015 12:00:00 AM". the csv cell format is DATE CUSTOM.

Can anyone please tell me how to convert the new data timestamp which is in DATE CUSTOM to the previous one in GENERAL format so that all timestamps old and new are in same format.

THanks

‌

[maxgro · Accepted solution]

maybe

Timestamp(Timestamp#(@1, 'DD/MM/YYYY hh:mm:ss tt'), 'DD/MM/YYYY hh:mm:ss')