Timestamp not working

[senior_freshmen]

hello Guys, 

I know this Topic was already posted alot, but none of the suggestions seem to resolve my Problem. 

I am uploading a CSV to an QS App and I would like to generate a MasterCalendar based on the transported Timestamp. (I'm really sure the "Timestamp" Field is in fact text by the csv file)

But the convert to a real Timestamp does not happen, If I want to use one of the converted Fields and make them e.g. to display only Month, it won't work. 

Heres the script: 

And now when I try to process my fields this is the output: 

Thank y'all for your help and with best regards 

[mikaelsc]

timestamp(timestamp#(Created,'DD.MM.YYYY hh:mm')) ?

and your master calendar won't work, as you are trying to link a timestamp with a date. 

if you don't care about the hours in your master calendar, create a date field in your facts table :  date(floor(timestamp#(Created,'DD.MM.YYYY hh:mm'))) as Date, and generate a master calendar with "Date"

[MayilVahanan · Accepted solution]

Hi @senior_freshmen 

Try like below

Timestamp(Timestamp#(Created,'DD.MM.YYYY HH:mm'),'DD.MM.YYYY HH:mm') as TimeStamp2

or, can you please attach the excel sheet.