How to create a timestamp Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic for Current User Printer Friendly Page Subscribe to RSS Feed Report Inappropriate Content How to create a timestamp Completely stupid question, which is likely why I can't see an obvious answer on here, but how do you make a timestamp field? I have a date, and a time, and I'd like it to be formatted like 'DD/MM/YYYY hh:mm:ss' I've tried timestamp(Date&' '&Time,'DD/MM/YYYY hh:mm:ss') with no success. I know this is really simple, so sorry for the stupid question! Subscribe by Topic: QlikView App Dev QlikView App Dev All forum topics Subscribe to RSS Feed Report Inappropriate Content TimeStamp(Time + Date, 'DD/MM/YYYY hh:mm:ss') View solution in original post Subscribe to RSS Feed Report Inappropriate Content TimeStamp(Time + Date, 'DD/MM/YYYY hh:mm:ss') Subscribe to RSS Feed Report Inappropriate Content you should use Timestamp# before Timestamp to interpret your fields like a Timestamp, like this:

Timestamp(Timestamp#(your_date_field&your_hour_field, 'DD/MM/YY hh:mm:ss')) Subscribe to RSS Feed Report Inappropriate Content Perfect! Thanks All! Subscribe to RSS Feed Report Inappropriate Content don't we need to use the Timestamp#() function when we want to evaluate non Timestamp field(s) as a Timestamp ? Or it is just another trick you used here ? Subscribe to RSS Feed Report Inappropriate Content Since both Date and Time have an underlying numeric value, all you need to combine them is to add them together using a plus sign Subscribe to RSS Feed Report Inappropriate Content Subscribe to RSS Feed Report Inappropriate Content Following this question, this may seem even more stupid but where do you write TimeStamp(Time + Date, 'DD/MM/YYYY hh:mm:ss') ? Is it on the data load manager? new_to_qlikview new to qlikview qlikview_scripting qlikview_layout_visuali… qlikview_deployment qlikview_creating_analy… qlikview_publisher qlikview_extensions All Forums GeoAnalytics QlikView Qlik NPrinting