topic Re: assigning date value to parameter in Water Cooler

assigning date value to parameter

arezoo99 — Mon, 17 Dec 2018 12:48:54 GMT

i am getting decimal numbers "0.00034979303911852" assigned to my variable "New_Date" in the script below instead of getting "43451". would you please advise what the problem is

LET New_Date=peek('GRA_Date',0,'NewGearTB');

Re: assigning date value to parameter

sunny_talwar — Mon, 17 Dec 2018 12:52:06 GMT

How is GRA_Date created in NewGearTB table?

Re: assigning date value to parameter

arezoo99 — Thu, 03 Jan 2019 11:18:24 GMT

GRA_Date is extracted from database and is showing correct date but while using peek function I am getting wrong date.

I need to assign the date to a parameter

Re: assigning date value to parameter

sunny_talwar — Fri, 04 Jan 2019 12:16:19 GMT

Would you be able to share a sample to check this out?