T timpepu Registered User. Local time Today, 13:21 Joined Nov 6, 2009 Messages 22 Apr 27, 2010 #1 Hi ! I like to change the day value looking like this when I export it to txt file day examble 22.4.2010 15:46:58 should be like this 100422154658 I tried many times but not get it ? Br Timo
Hi ! I like to change the day value looking like this when I export it to txt file day examble 22.4.2010 15:46:58 should be like this 100422154658 I tried many times but not get it ? Br Timo
N namliam The Mailman - AWF VIP Local time Today, 22:21 Joined Aug 11, 2003 Messages 11,695 Apr 27, 2010 #2 Try using the format function YYMMDDHHNNSS should do the trick
T timpepu Registered User. Local time Today, 13:21 Joined Nov 6, 2009 Messages 22 Apr 27, 2010 #3 namliam said: Try using the format function YYMMDDHHNNSS should do the trick Click to expand... Now I get it ! Thaks for your help !
namliam said: Try using the format function YYMMDDHHNNSS should do the trick Click to expand... Now I get it ! Thaks for your help !
T timpepu Registered User. Local time Today, 13:21 Joined Nov 6, 2009 Messages 22 Apr 27, 2010 #4 timpepu said: Now I get it ! Thaks for your help ! Click to expand... One question more ! I'd like to get right time in this format when I run query !
timpepu said: Now I get it ! Thaks for your help ! Click to expand... One question more ! I'd like to get right time in this format when I run query !
N namliam The Mailman - AWF VIP Local time Today, 22:21 Joined Aug 11, 2003 Messages 11,695 Apr 27, 2010 #5 right time?? What right time? what do you mean?
T timpepu Registered User. Local time Today, 13:21 Joined Nov 6, 2009 Messages 22 Apr 27, 2010 #6 namliam said: right time?? What right time? what do you mean? Click to expand... I mean time when I run query because I want to export that time to the txt file !
namliam said: right time?? What right time? what do you mean? Click to expand... I mean time when I run query because I want to export that time to the txt file !
N namliam The Mailman - AWF VIP Local time Today, 22:21 Joined Aug 11, 2003 Messages 11,695 Apr 27, 2010 #7 You looking for the function of Now() which will show the current date and time?
T timpepu Registered User. Local time Today, 13:21 Joined Nov 6, 2009 Messages 22 Apr 27, 2010 #8 namliam said: You looking for the function of Now() which will show the current date and time? Click to expand... Yes I have tried , now I have to find how I can use format function with this Now() function
namliam said: You looking for the function of Now() which will show the current date and time? Click to expand... Yes I have tried , now I have to find how I can use format function with this Now() function
T timpepu Registered User. Local time Today, 13:21 Joined Nov 6, 2009 Messages 22 Apr 27, 2010 #9 timpepu said: Yes I have tried , now I have to find how I can use format function with this Now() function Click to expand... I got it ! Thanks !
timpepu said: Yes I have tried , now I have to find how I can use format function with this Now() function Click to expand... I got it ! Thanks !