Datetime

[crimmelcp]

I am importing scanned data from a windows CE device

one of the fields is comming in as a datetime

time("h:0m am",Datetime) converts the time to a character field
works fine

I need to extract the date.

I have tried date, cdate,substring and none work



Thanks
charlie Crimmel

[Tom Cone Jr]

Re: Datetime

Are you unable to extract the date from the datetime field or from the character string you get using time() ? It's not clear.

[csda1]

Re: Datetime

Hi Charlie,

Time(format, value) requires value to be type "T". If your imported value is any other type (probably character type), you need to convert it to a time type 1st to use the Time() function.

Show some examples of the imported data's format.

Assuming it's layout of character data is mm/dd/yyyy hh:mm:ss

use CTODT(value) in the formula like

time("h:0m am",CTODT(value))

[crimmelcp]

Re: Datetime

The table comes in from the CE handheld scanner as a Datetime field.
see attached jpg

this function converts the datetime field and gives me the correct time
time("h:0m am",Datetime)


I cannot get the date to extract from the datetime field in the table

Charlie Crimmel

[csda1]

Re: Datetime

Hi Charlie,

It looks like a Type "T", but go into the database structure and tell/show us what the field type and width is.

[crimmelcp]

Re: Datetime

It is a Type T

see attached

[csda1]

Re: Datetime

Hi Charlie,

In re-reading your question, I thought you were looking for the time, not the date. To get the date type from a time type either make sure the destination variable is a date type, e.g.

dim datevalue as D
datevalue=datetime

or, if using in an expression, where you can't assign the type before hand, the easiest way I use is

ctod(dtoc(now()))

[crimmelcp]

Re: Datetime-Almost have it

see attached

I almost have it
I can take a field defined as datetime and convert it to char date and time
(datec) and (timec)

I can also convert the datetime field to a date field (date)

I can convert the hours and minutes to numeric fields

But I still cannot convert the datetime field to a time field that shows only the time.
Any more ideas?

Charlie crimmel

[csda1]

Re: Datetime

If you want short time, output

shorttime=CTOT(chartime) ' Chartime to short time
shorttime=ctot(time("0h:0m:0s",longtime)) ' longtime to shorttime

chartime=time("0h:0m:0s",longtime) ' longtime to chartime
chartime=time("0h:0m:0s",ctodt("01/01/1000 "+mask(cshorttime(shorttime)," : : "))) ' shorttime to chartime

[crimmelcp]

Re: Datetime

Thank You Ira

[crimmelcp]

Re: Datetime-one more thing

what is type Y

see attached

[csda1]

Re: Datetime

Hi Charlie,

Type "Y" means short time (a typed field holding a time value)