UtterAccess Discussion Forums > Changing the date format in a variable

Full Version: Changing the date format in a variable

UtterAccess Discussion Forums > Microsoft® Access > Access Date + Time

marcusdias

Aug 19 2004, 10:39 AM

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.

Marcus

marcusdias

Aug 19 2004, 11:06 AM

I completely forgot the 'Format' function. So I just used this code:

CODE

stDay = DateSerial(Year(Date), Month(Date), 1)
mySendKeys Format(stDay, "dd.mm.yyyy"), True
wait (1)

Marcus

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.