Format date to DDMMYY with a text colour formula field

Answer

You could always try setting up a var for each piece of the date similar to this:

var text MM = Right(ToText(Month([date field])+100),2);

This would grab the MM piece and you would do similar formulas for DD and YY and then just connect them like this:

$DD & $MM & $YY

Was this answer helpful?

Answer posted by:
Blake Harrison - DataBlender , Data Mixologist
QuickBase Solution Provider a month ago



1 comment

Thanks Blake. I found how to use ToFormattedText( [date field],"DDMMYYYY") and where to put it in my formula which was super simple.

• Sarah
• a month ago