Compile error with format date and time

[aman1234]

Hi guys

When I use the format command with date or time as in the following query then it gives me compile error Expected End of statement.

Please Login or Register  to view this content.

Can anyone please tell me how can I change the format of date or time in select statement.

Regards
Aman

[DonkeyOte]

Aman, first I think we would need to know the Database you're using given the SQL will vary accordingly (ie Access, MySQL, SQLSvr, Oracle, even XL itself)... presumably ScanDate & Time are separate fields ?

[aman1234]

Hi ya

Thanks for your reply. Well the database is in Access and the frontend is excel. The scandate and time are two different fields. Scandate and time both has date/time data type. I have set the format property of scandate to short date and Time format property is set to short time.


I hope now you got the required information.

Regards
Aman

[DonkeyOte]

OK, try:

Please Login or Register  to view this content.

quotation marks (") are seen as marking beginning / end of string in VBA... if you need to use literally then quote again
(or you can use: string & Chr(34) & "dd/mm/yyyy" & Chr(34) & rest of string)

[aman1234]

Thanks a lot for your help. It worked absolutely fine.

Cheers