I have a function that fill up a SAP form, thru API SendKeys routine, but the problem that i got is that one of the field that i need to fill is a date field, and must be the 1st day of the current month. the problems is the only format that the SAP accepts (I'm case at least) is dd.mm.yyyy or ddmmyy. The function that I'm using to the get the first day of the month is 'DateSerial(Year(Date), Month(Date), 1)', but it just return the date in the dd-mm-yyyy format. Does someone know a change the date format? A function? Any help will be great! Thanks in advance.