+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Date Function (/Thread-Date-Function)
Date Function - nilu verma - 07-22-2008
Hi,
I want to get System Date Minus time in my checkpoint. My checkpoint fails because my Expected Value is the System Date & my Actual Value is the System Date + Time . I need to retreive only Date & not time from my Datatable . Is there any way we can do that & how it needs to be done.
Thanks in Advance,
Nilu Verma
RE: Date Function - gammaflare - 07-23-2008
The TODAY() Function and the NOW() Function
The TODAY function returns the serial number of today's date based on your system clock and does not include the time. The NOW function returns the serial number of today's date and includes the time.
So, make an entry in your datatable without the quotes "=TODAY()"
RE: Date Function - surya_7mar - 07-28-2008
Get the Date only using the Date (Build in constant)
RE: Date Function - QADBA - 07-28-2008
Depending on which format you need, you can get the data also separately:
Day(now)
Month(now)
Year(now)
RE: Date Function - Rajashekar Gouda - 07-28-2008
You can use date() function. This will display the system date(usually in mm/dd/yyyy formate)
example:
Code:
Dim tdate
tdate=date()
msgbox tdateRegards
Raj