
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Timestamp not working
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
- Subscribe by Topic:
-
Application Development
-
Creating Analytics
-
Layout & Visualizations
-
Other
-
Scripting
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Please close the thread by marking correct answer & give likes if you like the post.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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"

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Please close the thread by marking correct answer & give likes if you like the post.
