A Accessor New member Local time Today, 14:04 Joined Sep 15, 2009 Messages 3 Sep 15, 2009 #1 I am trying to combine two seperate fields (time and date). I can do this by just using and "&" in between the fields in a new field but lose the ability to format as a general date/time record. Any ideas?
I am trying to combine two seperate fields (time and date). I can do this by just using and "&" in between the fields in a new field but lose the ability to format as a general date/time record. Any ideas?
boblarson Smeghead Local time Today, 11:04 Joined Jan 12, 2001 Messages 32,040 Sep 15, 2009 #2 Don't use the & but instead use + (for date/time concatenation because technically they are numbers behind the scenes).
Don't use the & but instead use + (for date/time concatenation because technically they are numbers behind the scenes).
A Accessor New member Local time Today, 14:04 Joined Sep 15, 2009 Messages 3 Sep 15, 2009 #3 Can I change the format to something like this 01/01/09 14:15?
V voslica Registered User. Local time Today, 14:04 Joined Aug 24, 2006 Messages 32 Sep 16, 2009 #4 try using Format([new date],"mm/dd/yy h:m") where [new date] is your combined date and time fields
boblarson Smeghead Local time Today, 11:04 Joined Jan 12, 2001 Messages 32,040 Sep 16, 2009 #5 voslica said: try using Format([new date],"mm/dd/yy h:m") where [new date] is your combined date and time fields Click to expand... You should use n for minutes - h:n
voslica said: try using Format([new date],"mm/dd/yy h:m") where [new date] is your combined date and time fields Click to expand... You should use n for minutes - h:n
