var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Is this possible?
I have one field in a table which contains the date in the following format:
The table I need to append this data to, however, structures the date data differently. There are 3 separate fields:
year, month, day
Is there anyways I can import the mm/dd/yy field into the year, month, day fields? iF so, how can I do this?
You can use Date function
You can use that in SQL or in a Access module
JefB - hope it helps
You can use the DatePart functiont to do this.
if orderdate = #06/15/02#
DatePart("m",[OrderDate]) would return 6
DatePart("yyyy",[OrderDate]) would return year (the actual format is base on the regional date setting in the control panel. 2002 in my case.
Look in help for datepart functionfor more info
Thanks alot for your help
I would like to covert the year for ALL the "day/month/year" records in my field.
When I create a query using the expression - DatePart("yyyy",[OrderDate]) - it gives all my records with the same year (ie: 1990)
How can I make it so i get the following results:
so that every record it given the new year format that matches its original field.
my silly mistake, ignore last posting
it worked perfectly