num,timestamp?

[Anonymous]

Can any one explain example with

num,num#, time ,timestamp#   function.

i dont want the examples from help document

give me some general examples?

[amit_saini]

Hi,

Check below:

http://community.qlik.com/message/538516#538516

Thanks,
AS

[MK_QSL]

The Date Function

Date and Date# is explained here.. The same way other works.

[tresesco]

I explained similar, see, if this helps: http://community.qlik.com/message/538561#538561

[its_anandrjs · Accepted solution]

Hi,

Read this posts

For Num and Num#

http://community.qlik.com/message/538561#538561

For Time and TimeStamp#

Ex:- Assume this example

Load Date,

TimeStamp(TimeStamp#( Date,'MM/DD/YYYY hh:mm'),'MM/DD/YYYY hh:mm') as TimeStampField,//For TimeStamp

Time(TimeStamp#( Date,'MM/DD/YYYY hh:mm'),'hh:mm') as TimeField; //For Time

Load * Inline  [

Date

12/24/2014 10:20

];

TimeStamp# :- This converts any string into timestamp number format

Time :- This convert any timestamp into Time.

Regards

Anand