Date Code Format

Legacy Poster

• 23 juillet 2015 13:14

Hi,

 

I'm trying to format a date to the following format dd/MMM/yyyy (ie. 23/Jun/2015

This date is currently received from a database field in the original format of 23/06/15

 

I'm using the following VB script of : value = Day(value) & "/" & Month(value) & "/" & Year(value) but if I try using MonthName it errors..

 

Any ideas?

 

Bartender 9.4 SP3

 

Thanks

Mark

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • 29 juillet 2015 01:44

  SetLocale("en-us")
  dd = Mid(Value,1,2)
  mmm = MonthName(Mid(Value,4,2),true)
  yy = "20" & mid(Value,7,2)
  value = dd & "/" & mmm & "/" & yy
  

  (Set locale is not needed when your PC language is set to English)

   

  From BarTender 10.0, you can apply custom date format to database field so you don't have to use VB Script anymore.

  0

Vous devez vous connecter pour laisser un commentaire.