Date Code Format

Legacy Poster

• 2015年07月23日 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 ★

  • 2015年07月29日 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

請登入寫評論。