Format date when exporting

[timpepu]

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

 

[namliam]

Try using the format function YYMMDDHHNNSS should do the trick

 

[timpepu]

Try using the format function YYMMDDHHNNSS should do the trick

Now I get it !

Thaks for your help !

 

[timpepu]

Now I get it !

Thaks for your help !

One question more !

I'd like to get right time in this format when I run query !

 

[namliam]

right time?? What right time? what do you mean?

 

[timpepu]

right time?? What right time? what do you mean?

I mean time when I run query because I want to export that time to the txt file !

 

[namliam]

You looking for the function of Now() which will show the current date and time?

 

[timpepu]

You looking for the function of Now() which will show the current date and time?

Yes I have tried , now I have to find how I can use format function with this Now() function

 

[timpepu]

Yes I have tried , now I have to find how I can use format function with this Now() function

I got it !

Thanks !