Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Transforming a date to MM/DD/YYYY

    Hi,

    I have a date that looks like 08may2002. How do I transform this into a date that is 05/08/2022? Code below shows how my dates are. Thanks-CJ

    Code:
    Code:
    * Example generated by -dataex-. For more info, type help dataex
    clear
    input float booking_date
    21437
    21437
    22043
    22043
    21243
    21243
    21243
    21243
    22168
    22168
    22168
    22168
    22229
    22229
    22229
    22229
    22336
    22336
    22336
    22336
    21810
    21243
    21243
    21243
    21416
    21416
    21416
    21808
    21808
    21808
    21793
    21793
    21874
    21874
    21874
    21445
    21480
    21795
    21563
    21563
    21340
    21340
    21222
    21222
    21880
    22239
    22239
    21702
    22306
    21704
    21704
    21280
    21600
    21600
    21228
    21228
    21228
    21196
    21196
    21196
    21263
    21584
    21651
    21810
    22377
    21626
    21468
    22156
    22156
    22308
    22308
    22054
    22054
    22614
    22614
    21960
    21960
    21960
    21960
    21960
    21305
    21305
    21664
    21664
    21894
    21894
    21894
    21291
    21291
    21986
    21986
    21894
    21894
    21894
    21957
    21957
    22424
    22424
    22533
    22533
    end
    format %td booking_date

  • #2
    try the following:
    Code:
    format %tdNN/DD/CCYY booking_date
    for the complete list of possibilities, see
    Code:
    help datetime_display_formats

    Comment

    Working...
    X