Date Code Format

Legacy Poster

• July 23, 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 ★

  • July 29, 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

Please sign in to leave a comment.