Return A Date Format

Comments

• garak Member Posts: 3,263

  2006-11-07

  For the name of the month, you can use the date table

  Do you make it right, it works too!

  0
• ara3n Member Posts: 9,258

  2006-11-07

  Mydate := 04302006D;
  mystr := format(Mydate,0,'<Month Text> <Day>, <Year4>');
  message(mystr);
  

  Ahmed Rashed Amini
  Independent Consultant/Developer
  
  
  blog: https://dynamicsuser.net/nav/b/ara3n

  0
• zeninoleg Member Posts: 236

  2006-11-07

  OldDate := '30042006';
  EVALUATE(DayVar, COPYSTR(OldDate, 1,2));
  EVALUATE(MonthVar, COPYSTR(OldDate, 3,2));
  EVALUATE(YearVar, COPYSTR(OldDate, 5,4));
  
  MESSAGE('%1', FORMAT(DMY2DATE( DayVar,MonthVar,YearVar), 0, '<Month Text, 3> <Day>, <Year4>'));
  

  This should work

  Best Regards,
  Oleg

  0
• ricky76 Member Posts: 204

  2006-11-07

  Cheers for your help

  0
• ara3n Member Posts: 9,258

  2006-11-07

  you are welcome. You should take a look at developer manual.

  Ahmed Rashed Amini
  Independent Consultant/Developer
  
  
  blog: https://dynamicsuser.net/nav/b/ara3n

  0