How to identify the sap date format.

[Ankesh]

I would suggest you to use mmddyyyy format as it will be easier for you. You can use Date() for this.

Anyways, to get the date in your desired format, you can always create them using the below code...

Code:

daytoday=Day(Now)
currentMont=Month(Now)
currentyear=Year(Now)

Now you have the day, month and year value . you can make them as you want.

eg.
for DD.MM.YYYY use daytoday&"."&currentMont&"."&currentyear

Similar way you can make any combination.

Regards,
Ankesh