CoNVERT date to text or code

karuchua

hello all,

is it possible to achieve either of the above?
convert date to code or text.

Gurn37

Hi,

Use the FORMAT function.

Regards
G.

karuchua

i have it but giving me a funny output,not the date

Luc_VanDyck

Describe "funny output"

karuchua

this is the date 12/03/12 i want to convert to code but this is what i get 41246

Luc_VanDyck

And how does your code looks like?

karuchua

Row:=Row+1;
[b]EnterCell(Row,1,FORMAT("Order Date"),FALSE,FALSE,FALSE);[/b]
EnterCell(Row,2,"No.",FALSE,FALSE,FALSE);
EnterCell(Row,3,"Sell-to Customer No.",FALSE,FALSE,FALSE);
EnterCell(Row,4,"Sell-to Country/Region Code",FALSE,FALSE,FALSE);
EnterCell(Row,5,FORMAT(Amount),FALSE,FALSE,FALSE);
EnterCell(Row,6,FORMAT("Customs Entry No"),FALSE,FALSE,FALSE);
EnterCell(Row,7,FORMAT("Exit Doc Received?"),FALSE,FALSE,FALSE);

Luc_VanDyck

Try

txtOrderDate := FORMAT("Order Date");
MESSAGE(txtOrderDate);

to see the date is converted to text correctly. It's possibly Excel that displays them different ... which was not mentioned in your original question. You need to place a ' character before your order date, so it's treated as text by Excel.

karuchua

@Luc Van Dyck,thxs and sorry for not clarifying about the excel, yes it formats on message,what do you mean by placing a character before the order date.

Savatage

by putting a ' to start your field excel will look at is as text and not a formula.

See here:
viewtopic.php?f=23&t=24043

karuchua

@savatage and @Luc Van Dyck,thxs man,it worked.

i added ''''+format(orderdate) and it good now.

Luc_VanDyck

Please mark your topic as solved. See forum rules #3.9