Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
rajarshi_guin
Contributor III
Contributor III
‎2017-06-07 05:49 AM

How to convert a date field to a timestamp field

Hi,

I want to store the current date of previous year along with the time as 12:00 AM in a variable. For example, today's date is 06/07/2017. So, I need to store the value as 07-Jun-16 12.00.00.000000 AM. The time need to be 12.00.00.000000 AM always. Also the date needs to be in the format DD-MMM-YY. Can anyone please let me know how to store this in a variable.

220 Views
0 Likes
1 Reply
sunny_talwar
MVP
MVP
‎2017-06-07 09:02 AM

May be just this

TimeStamp(Date, 'DD-MMM-YY hh.mm.ss.ffffff TT') as TimeStamp

202 Views
0 Likes