Wingate & Crystal

From: Drew (drew_style_is_alive_at_hotmail.com)
Date: 07/14/03 

Date: 14 Jul 2003 10:58:19 -0700

I have been using Wingate and need to investigate the History.dbf file
that holds all the internet activity.

I need to find out how to convert the date/time field, which I know
how to in excel but I want to do this using Crystal Report Writer but
the formula in excel is not usable in Crystal.

Does anyone have any idea how convert the number field to a date/time
field in Cystal

Cheers in advance

Drew

Relevant Pages

  • Re: Help me Help !!!!
    ... Rick Brandt the second problem that i have that when i need to export my data ... Ms excel so i used the command "Anaylze it with Ms Excel" from Tools menu ... >> that is for Date of Birth i mean Date/Time field. ... >> so plz i need help that can support both ...
    (microsoft.public.access.tablesdbdesign)
  • Re: 30/12/1899 Error when importing Time from Excel to Access
    ... Both Access and Excel store dates as double-precision numbers. ... Date/Time field to a Double (choose Number as the type and Double as the ... Exam Time Final ... Any idea how to get rid of 30/12/1899 and where it comes from? ...
    (microsoft.public.access.externaldata)
  • Re: Need a Date Two Ways
    ... When the data is exported into Excel and then imported into another database ... the format needs to be a numbered month i.e. "7" in one column and a numbered ... Store a Date/Time field in your table; set the Format property of the ...
    (microsoft.public.access.tablesdbdesign)
  • number to text problem
    ... I was able to cut & paste tabular data from the web to an excel sheet. ... Note: when the cell is displaying 32:31:00 and if I click on it it ... date/time field although the Access field is defined as text. ...
    (microsoft.public.excel.misc)