Date time will not appear after export to excel

jane85_help · June 14, 2011, 5:29am

Hi All,

why the datetime cannot appear after export to excel?

Any format need to use for display datetime?

Thank you.

dkartiq · June 14, 2011, 6:07am

Use like this.

XlSheet.Range(‘A1’).Value:=FORMAT(Date value,0,0);

jane85_help · June 17, 2011, 6:03am

Hi, Kathik D, still not working[:(]

I try to debug, the date time value is null but table there actualy got value, only this column got problem…[:(]

dkartiq · June 17, 2011, 9:28am

What is the field class of this date field?

jane85_help · June 20, 2011, 1:40am

Hi,

I checked, the datetime column is get from a datetime picker…

I drop down the column…and it come from a datetime picker

kartiktanna · June 20, 2011, 3:23am

Hi, Use dateValue() method to read the date from DateEdit control. Also you can consider using date2str and str2date functions in order to export the date value as datetime or a string respectively.

Thanks

jane85_help · June 20, 2011, 4:56am

Can you show me some example?

Because I cannot find any example in C/SIDE Reference Guide

mohana_cse06 · June 20, 2011, 6:15am

First calculate the date from datetime by using the following function

Date := DT2DATE(Datetime)

and then export

jane85_help · June 20, 2011, 7:41am

Hi,

The field still blank…

http://imageshack.us/photo/my-images/21/datetime.jpg/

Do you have any other idea?

mohana_cse06 · June 20, 2011, 7:45am

“PV Job Material Requirement” is the same record or different record?

If you try

Message(’%1’,“PV Job Material Requirement”.“Requested Delivery Date”);

are you getting any datetime?

micheal_098 · June 20, 2011, 11:45am

Define the number format when you are passing the Dete time field to XL sheet

FOR DATE

Xlwrksht.Range(FORMAT(ColumnName)+FORMAT(Row)).NumberFormat :=“m/d/yyyy”.

FOR TIME

Xlwrksht.Range(FORMAT(ColumnName)+FORMAT(Row)).NumberFormat :="[$-F400]h:mm:ss AM/PM"

U can find these formats in XL by using MACROS…

jane85_help · June 21, 2011, 5:20am

hi,

It is blank…

but the other column got value.[:(]

mohana_cse06 · June 21, 2011, 5:55am

is Message(’%1’,“PV Job Material Requirement”.“Requested Delivery Date”); blank?

if yes, what r u expecting from blank? does it has value? check in table.

jane85_help · June 21, 2011, 6:10am

But table there got value.

mohana_cse06 · June 21, 2011, 6:13am

Where did you get PV Job Material Requirement record?

this problem is not with excel, you are not getting the correct record to export

micheal_098 · June 21, 2011, 6:33am

Which field do u want…?

jane85_help · June 21, 2011, 6:47am

i very curious, why the other columns from the same table will not blank, only this column blank…[:(]

thanks for your guys helping…

mohana_cse06 · June 21, 2011, 6:54am

Can you show us the total coding and screenshot of the table record

jane85_help · June 22, 2011, 9:09am

Hi All,

I solved the problem.

I use CALCFIELD method.

Thanks for helping…[:D]