CStr({Transaction.TicketNumber})

 

the value is the table is 8482931 and is being rendered as 8.482.931.00 how can I get the value without decimals and periods?

 

 

 

CStr(CDate({Transaction.DateOut}),"MM/dd/yyyy HH:mm")

 

the value in the table is 2/6/12 6:49 am and I need to get the value 2/6/2012 6:49am

 

Thank you.

CStr(CDate({Transaction.DateOut}),"MM/dd/yyyy HH:mm")

 

The DateOut is a datetime field in the table.

 

I get 02/06/2012 HH:mm and would like to see 02/06/2012 6:49am

although you can handle all of the formatting by right clicking on the original datetime field

select format field

datetime tab

pick the one you want or use customize