Hi all,

From an outlook personal Form I export data to Excel,

1 ) I export Item.CreationTime but just want to have the date in this
format dd/mm/yyyy so I put MyDate in a Cell
MyDate =
day(MyItem.CreationTime)&"/"&Month(MyItem.CreationTime)&"/"&
year(MyItem.CreationTime)

Question 1)
In somme cells I have the right result eg: dd/mm/yyyy but in other
I have mm/dd/yyyy
Why ?????

Question 2) Is there A property Creation Date in this format dd/mm/yyyy
I tryed item.startDate but this value isn't always usable

2 ) I try to evaluate Item.CreationTime I Transfomed dates like this
20061113 year*10000+month*100+day
and I try this
A) if 20061005 mydatetransformed and mydatetransformed 20061114
then

B) DateA = 20061005
DateB = 200611014
A) if DateA mydatetransformed and mydatetransformed
DateB then

the Eg: A works but not the Eg: B why ? how can I do ?

Tks a lot