Need to convert decimal datetime to ddMONYY

wjalford

I am using a datetime prompt to pull in the start date and end date for my sql query.  The date prompt is using decimal.  How do I convert the decimal to ddMonyy format.  My code is below.  You will see in my select that I have t1.Login_Date with the variable startDT and t1.Login_Date with the variable endDT.  This is where I need to convert the decimal to the date.  I have tried Cast and convert and both together and cannot get it to work.  Any help would be greatly appreciated.

 

NamesDefaultToHere(1);

// Written by Vince Faller

txnelson

Here is a simple example to do the conversion you want

Names Default To Here( 1 );

theDate = Today();

charDate = Uppercase( Format( theDate, "ddmonyyyy" ) );
Show( charDate );

finalDate = Substr( charDate, 1, 5 ) || Substr( charDate, -2 );
Show( finalDate );