Date > Timestamp

[3guk]

Hey Guys,

 

Using a calendar generation script that requires all of my eventstart field and eventend field to be timestamps rather than dates.

 

Since all of my events are dates I've had my database set up with just date fields.

 

Can I use a calculation to generate new fields which take the date field and spit out a timestamp of date + a time of 00:00 ?

 

Any ideas?

 

Thanks

 

James

[eos]

Use

 

Timestamp ( yourDateField ; Time ( 0 ; 0 ; 0 ) )

[LaRetta]

I believe that GetAsTimeStamp ( theDate ) would works also.  :-)

[eos]

Indeed it does – not as explicit, but less wear and tear on the old keyboard … 

[comment]

less wear and tear on the old keyboard … 

 

If that is a concern, consider =

Timestamp ( Datefield ; 0 )

[LaRetta]

I just love this stuff !  Thanks for the fun guys!

Wait ... wait ... where's Daniele?

[Raybaudi]

I'm here ( as Always )
 
Another way ( simpler )
 

Datefield  // calculation result TimeStamp

 
LOL