topic Re: Date with time in QlikView https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342080#M830302 <HTML><HEAD></HEAD><BODY><P>Then what is use of timestamp.</P><P>Please explain.</P><P>with example simple.</P></BODY></HTML> Thu, 22 Jun 2017 12:09:48 GMT Anonymous 2017-06-22T12:09:48Z Date with time https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342071#M830281 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Need to know =Date(Time(12/01/2017 4PM),'DD/MM/YYYY hTT');</P><P>i got wrong answer.</P><P>Please tell me the 4pm result must be show.</P><P></P><P></P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342071#M830281 Anonymous 2020-11-25T16:16:04Z Re: Date with time https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342072#M830284 <HTML><HEAD></HEAD><BODY><P>I am not sure, What are you expecting over here, May be this?</P><P><STRONG>=Date(Date#('12/01/2017 4PM', 'DD/MM/YYYY hTT'),'DD/MM/YYYY htt')</STRONG></P></BODY></HTML> Thu, 22 Jun 2017 11:56:57 GMT https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342072#M830284 Anil_Babu_Samineni 2017-06-22T11:56:57Z Re: Date with time https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342073#M830287 <HTML><HEAD></HEAD><BODY><P>its correct. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 22 Jun 2017 12:01:08 GMT https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342073#M830287 Anonymous 2017-06-22T12:01:08Z Re: Date with time https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342074#M830289 <HTML><HEAD></HEAD><BODY><P>I want separate date and separate time.</P><P>Can you explain with expression ?</P></BODY></HTML> Thu, 22 Jun 2017 12:01:56 GMT https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342074#M830289 Anonymous 2017-06-22T12:01:56Z Re: Date with time https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342075#M830291 <HTML><HEAD></HEAD><BODY><P>Please close this thread by flag correct answer <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 22 Jun 2017 12:01:59 GMT https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342075#M830291 Anil_Babu_Samineni 2017-06-22T12:01:59Z Re: Date with time https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342076#M830293 <HTML><HEAD></HEAD><BODY><P>Date</P><P>=Date(Date#('12/01/2017 4PM', 'DD/MM/YYYY hTT'),'DD/MM/YYYY')</P><P></P><P>Time</P><P>=Date(Date#('12/01/2017 4PM', 'DD/MM/YYYY hTT'),'htt')</P></BODY></HTML> Thu, 22 Jun 2017 12:02:41 GMT https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342076#M830293 Anil_Babu_Samineni 2017-06-22T12:02:41Z Re: Date with time https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342077#M830295 <HTML><HEAD></HEAD><BODY><P>How to close the flag ?</P></BODY></HTML> Thu, 22 Jun 2017 12:04:42 GMT https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342077#M830295 Anonymous 2017-06-22T12:04:42Z Re: Date with time https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342078#M830297 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P></BODY></HTML> Thu, 22 Jun 2017 12:05:38 GMT https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342078#M830297 Anil_Babu_Samineni 2017-06-22T12:05:38Z Re: Date with time https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342079#M830300 <HTML><HEAD></HEAD><BODY><P>It means mark correct or helpful answer if you get answer ...</P></BODY></HTML> Thu, 22 Jun 2017 12:06:44 GMT https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342079#M830300 prma7799 2017-06-22T12:06:44Z Re: Date with time https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342080#M830302 <HTML><HEAD></HEAD><BODY><P>Then what is use of timestamp.</P><P>Please explain.</P><P>with example simple.</P></BODY></HTML> Thu, 22 Jun 2017 12:09:48 GMT https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342080#M830302 Anonymous 2017-06-22T12:09:48Z Re: Date with time https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342081#M830303 <HTML><HEAD></HEAD><BODY><H1 data-mc-conditions="Primary.NotToTranslate" style="font-size: 1.714em; margin: 0 0 10px; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif;"></H1><P style="font-size: 14px; margin: 10px 0; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif;"><SPAN class="statement" style="font-weight: bold;">TimeStamp()</SPAN> formats an expression as a date and time value, in the timestamp format set in the system variables in the load script, or in the operating system, unless a format string is supplied.</P><P class="syntax_heading" data-mc-autonum="Syntax: " style="font-size: 14px; margin: 10px 0; font-weight: bold; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif;"><SPAN class="autonumber">Syntax: </SPAN> </P><P class="syntax" data-mc-conditions="Primary.NotToTranslate" style="font-size: 16px; margin: 10px 0; background-color: #f4f4f4; font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; color: #0f0f0f;"><SPAN class="statement" style="font-weight: bold;">Timestamp(</SPAN>number[, format]<SPAN class="statement" style="font-weight: bold;">)</SPAN></P><P class="syntax" data-mc-conditions="Primary.NotToTranslate" style="font-size: 16px; margin: 10px 0; background-color: #f4f4f4; font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; color: #0f0f0f;"><SPAN class="statement" style="font-weight: bold;"><BR /></SPAN></P><P style="font-size: 14px; margin: 10px 0; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif;"><SPAN class="statement" data-mc-conditions="Primary.NotToTranslate" style="font-weight: bold;">Timestamp#()</SPAN> evaluates an expression as a date and time value, in the timestamp format set in the load script or the operating system, unless a format string is supplied.</P><P class="syntax_heading" data-mc-autonum="Syntax: " style="font-size: 14px; margin: 10px 0; font-weight: bold; color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif;"><SPAN class="autonumber">Syntax: </SPAN> </P><P class="syntax" data-mc-conditions="Primary.NotToTranslate" style="font-size: 16px; margin: 10px 0; background-color: #f4f4f4; font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; color: #0f0f0f;"><SPAN class="statement" style="font-weight: bold;">timestamp#(</SPAN>text[, format]<SPAN class="statement" style="font-weight: bold;">)</SPAN></P><P><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"><BR /></SPAN></P><P><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"><BR /></SPAN></P></BODY></HTML> Thu, 22 Jun 2017 12:11:38 GMT https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342081#M830303 prma7799 2017-06-22T12:11:38Z Re: Date with time https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342082#M830304 <HTML><HEAD></HEAD><BODY><P>I would suggest you to use Help for basic questions</P><P><A href="http://help.qlik.com/en-US" title="http://help.qlik.com/en-US">Qlik | Help</A></P></BODY></HTML> Thu, 22 Jun 2017 12:12:16 GMT https://community.qlik.com/t5/QlikView/Date-with-time/m-p/1342082#M830304 Anil_Babu_Samineni 2017-06-22T12:12:16Z