Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
I would suggest you to use Help for basic questions