vaskoemilov
New member
- Local time
- Today, 18:13
- Joined
- Aug 22, 2011
- Messages
- 8
Hi, I'm begginer in access and i have the following problem:
In Acc Query i have field with Date/time type containing "16.1.2012 г. 21:00:00"
After separating date and time in two different fields (text type) i want to convert the date "Jan 16 2012", which is text into date/time type to link it to another table.
Tried DateValue(Format(CDate(left(all_bss_pmg_allbsspmg_cell_bhr_kpi.timestamp,11)),"dd\.mm\.yyyy")) AS [Date]
and different other combinations of them but i get errors.
Pls help
In Acc Query i have field with Date/time type containing "16.1.2012 г. 21:00:00"
After separating date and time in two different fields (text type) i want to convert the date "Jan 16 2012", which is text into date/time type to link it to another table.
Tried DateValue(Format(CDate(left(all_bss_pmg_allbsspmg_cell_bhr_kpi.timestamp,11)),"dd\.mm\.yyyy")) AS [Date]
and different other combinations of them but i get errors.
Pls help