Set Date British

[acwoo1]

Hi

oSheet:Cells( nRow, 5 ):Value=dtoc(date)

How to Set Date British.


Thanks


Regards

ACWoo
Using HWH1510
bcc582

[Massimo Linossi]

Cells(1, 1):Value = doc(date())
Cells(1, 1):NumberFormat = "dd/mm/yyyy"

[acwoo1]

Thanks Mr Massimo

The output:

04/01/2017
04/02/2017
04/03/2017
04/04/2017
04/05/2017
04/06/2017
04/07/2017
04/08/2017
04/09/2017
04/10/2017
04/11/2017
04/12/2017
13/04/2017
14/04/2017
15/04/2017
16/04/2017
17/04/2017
18/04/2017
19/04/2017
20/04/2017
21/04/2017
22/04/2017
23/04/2017
24/04/2017
25/04/2017
26/04/2017
27/04/2017
28/04/2017
29/04/2017
30/04/2017

The cells are formatted as: Custom; "dd/mm/yyyy"
The dates are not all in April. It is supposed to be all in April.
It is not formatted as date but formatted as custom in Excel.

Regards

ACWoo

[nageswaragunupudi]

Should be
oSheet:Cells( nRow, 5 ):Value= dDateValue // do not use DTOC