Serial Number as a Date

[nixdorf]

Hi, I don't know is possible to define a field with an automatic intro of 12 digits number: year/month-Day-hour-minute-second (12/0726184752). Is possible? Thanks!

[comment]

No, but it is possible to enter a serial number and translate it (in a calculation field) to the corresponding timestamp.

What would be the purpose here?

[Raybaudi]

No

Why not ?

For example this:

Let(

t = Get ( CurrentTimeStamp ) ;

Right ( Year ( t ) ; 2 ) & "/" &

Right ( "00" & Month ( t ) ; 2 ) &

Right ( "00" & Day ( t ) ; 2 ) &

Right ( "00" & Hour ( t ) ; 2 ) &

Right ( "00" & Minute ( t ) ; 2 ) &

Right ( "00" & Seconds ( t ) ; 2 )

)

in an auto-enter text field.

Naturally NOT to be used as an unique ID.

[comment]

Ahm... where is the serial part?

[Raybaudi]

I think he meant consecutive, not really serial

[nixdorf]

Thanks, really works!!

"Serial" number (for each job in my case) is necessary discontinued because the same number is an FTP access, thus in a single day there are 86400 possible numbers and never can be repeated a number

[comment]

the same number is an FTP access,

Not sure what that means.

in a single day there are 86400 possible numbers and never can be repeated a number

No, that's not true. There are 86400 seconds in a day, and if you (or another user) create more than one record in the same second, you will have a duplicate.