Date with time

[Anonymous]

Hi All,

Need to know =Date(Time(12/01/2017 4PM),'DD/MM/YYYY hTT');

i got wrong answer.

Please tell me the 4pm result must be show.

Thanks

[prma7799]

TimeStamp() 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.

Syntax:

Timestamp(number[, format])

Timestamp#() 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.

Syntax:

timestamp#(text[, format])

[Anil_Babu_Samineni]

I would suggest you to use Help for basic questions

Qlik | Help