DATE()

[ferdinandpagayatan]

how to add date to another date in my textbox
ex:

07/15/2015 + 07/25/2015=?

and how to add datepicker only in my forms.
thanks and more power.

 

[Olaf Doschke]

>n=ldStartDate - ldOtherDate + 1
Maybe just a misleading name, but start date typically is lower then the other date, if you subtract otherdate from startdate you get a negative number.
If you want a difference of dates either use ABS() or always subtract the lower/earlier/start date from the higher/later/end date.

Adding +1 is correct and can be seen from the extreme case both dates are equal you still have 8 hours on that single date, not 0.

In regard of the datepicker I second Mike. Also note what you tried and what problems you have with it. There are alternatives to the olecontrol, which doesn't work native on newer Windows versions, but you are allowed to redistribute and setup the ole control needed for the dtpicker and it works even on win8, though it looks outdated (no pun intended).

Bye, Olaf.

 

[JRB-Bldr]

Since we have no idea what you want to know about the DatePicker Object you might want to begin with the following webpage and its downloadable example code:
How to use the DateTimePicker control in Visual FoxPro

https://support.microsoft.com/en-us/kb/259646

Additionally you can do a Google search for: vfp datepicker object
Where you will find a number of references to look at.

One small piece of reference code that might be handy for you is how to get a Date from a DatePicker value on a VFP Form

Example:
[b]dFirstDate = TTOD(THISFORM.oleFirstDate._Value)[/b]  && One method of getting only the [u]Date[/u] portion from a DatePicker named:  oleFirstDate

Good Luck,
JRB-Bldr

 

[Mike Lewis]

Also, it's worth keeping in mind that the date picker does not support VFP-style blank dates - a common source of errors.

But I still think this should go into a new thread.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads