datetime input mask

I have a variable which is in long date format.
How could I create a textbox that input the date part only (that is
without the time portion)?

`set date to short` doesn't work.

--
.~. Might, Courage, Vision. In Linux We Trust.
/ v \ http://www.linux-sxs.org
/( _ )\ Linux 2.4.22-xfs
^ ^ 11:50am up 13 days, 12:22, 0 users, load average: 1.00, 1.00, 0.92

Stefan
Thu Feb 05 03:51:43 CST 2004


"toylet" <toylet@mail.hongkong.com> schrieb im Newsbeitrag
news:OIxaUt56DHA.2656@TK2MSFTNGP11.phx.gbl...
>
> I have a variable which is in long date format.
> How could I create a textbox that input the date part only (that is
> without the time portion)?

You cannot do it with an InputMask, I think.
Try TTOD() or, with a remote view, you can
DbSetProp(..,..,'DataType','D')

> `set date to short` doesn't work.

It's meant to take over the current O/S user's locale
display preferences.


hth
-Stefan

toylet
Thu Feb 05 06:08:16 CST 2004

can I do it without modifying the data type?
seems that I need to use another variable as an intermediate and do
conversion.

>> How could I create a textbox that input the date part only (that is
>> without the time portion)?
> You cannot do it with an InputMask, I think.
> Try TTOD() or, with a remote view, you can
> DbSetProp(..,..,'DataType','D')

sorry I mixed up.

>> `set date to short` doesn't work.
> It's meant to take over the current O/S user's locale
> display preferences.
--
.~. Might, Courage, Vision. In Linux We Trust.
/ v \ http://www.linux-sxs.org
/( _ )\ Linux 2.4.22-xfs
^ ^ 8:06pm up 13 days, 20:38, 0 users, load average: 1.00, 1.00, 0.93

swdev2
Thu Feb 05 18:29:43 CST 2004

Heya Let O Toy .
in the textbox - try for .value
=ttod(fieldname)
xie xie [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html
Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html
Mondo Cool Satellites -> http://www.efgroup.net/sat
mySql / VFP / MS-SQL, tis all, Mondo Cool..

"toylet" <toylet@mail.hongkong.com> wrote in message
news:OIxaUt56DHA.2656@TK2MSFTNGP11.phx.gbl...
>
> I have a variable which is in long date format.
> How could I create a textbox that input the date part only (that is
> without the time portion)?
>
> `set date to short` doesn't work.
>
> --
> .~. Might, Courage, Vision. In Linux We Trust.
> / v \ http://www.linux-sxs.org
> /( _ )\ Linux 2.4.22-xfs
> ^ ^ 11:50am up 13 days, 12:22, 0 users, load average: 1.00, 1.00,
0.92

Anders
Thu Feb 05 19:02:06 CST 2004

Don't bind the textbox to the datetime column. Make it's Value a date and
assign this value to the Datetime.
-Anders

"toylet" <toylet@mail.hongkong.com> wrote in message
news:O4694C#6DHA.2540@TK2MSFTNGP11.phx.gbl...
> can I do it without modifying the data type?
> seems that I need to use another variable as an intermediate and do
> conversion.
>
> >> How could I create a textbox that input the date part only (that is
> >> without the time portion)?
> > You cannot do it with an InputMask, I think.
> > Try TTOD() or, with a remote view, you can
> > DbSetProp(..,..,'DataType','D')
>
> sorry I mixed up.
>
> >> `set date to short` doesn't work.
> > It's meant to take over the current O/S user's locale
> > display preferences.
> --
> .~. Might, Courage, Vision. In Linux We Trust.
> / v \ http://www.linux-sxs.org
> /( _ )\ Linux 2.4.22-xfs
> ^ ^ 8:06pm up 13 days, 20:38, 0 users, load average: 1.00, 1.00,
0.93

toylet
Thu Feb 05 21:28:56 CST 2004

is this for display only? input?

swdev2 wrote:

> Heya Let O Toy .
> in the textbox - try for .value
> =ttod(fieldname)
> xie xie [Bill]

--
.~. Might, Courage, Vision. In Linux We Trust.
/ v \ http://www.linux-sxs.org
/( _ )\ Linux 2.4.22-xfs
^ ^ 11:28am up 14 days, 12:00, 0 users, load average: 1.00, 1.00, 0.99

toylet
Thu Feb 05 21:30:19 CST 2004

you meant to copy the datetime column from the view to another column
and then convert the modified value back into it? sounds promising...

Anders Altberg wrote:

> Don't bind the textbox to the datetime column. Make it's Value a date and
> assign this value to the Datetime.

--
.~. Might, Courage, Vision. In Linux We Trust.
/ v \ http://www.linux-sxs.org
/( _ )\ Linux 2.4.22-xfs
^ ^ 11:28am up 14 days, 12:00, 0 users, load average: 1.00, 1.00, 0.99

Anders
Mon Feb 09 08:44:05 CST 2004

Hi
That would be one way. Or copy to a variable that the texctbox is bound to.
-Anders

"toylet" <toylet@mail.hongkong.com> wrote in message
news:#AP4GGG7DHA.632@TK2MSFTNGP12.phx.gbl...
> you meant to copy the datetime column from the view to another column
> and then convert the modified value back into it? sounds promising...
>
> Anders Altberg wrote:
>
> > Don't bind the textbox to the datetime column. Make it's Value a date
and
> > assign this value to the Datetime.
>
> --
> .~. Might, Courage, Vision. In Linux We Trust.
> / v \ http://www.linux-sxs.org
> /( _ )\ Linux 2.4.22-xfs
> ^ ^ 11:28am up 14 days, 12:00, 0 users, load average: 1.00, 1.00,
0.99