{DATE} tag formatting help

[RickH]

As part of my Challenge 25 (age restriction check) i have a popup appear informing the cashier that the date of birth from an ID check needs to be on or before this date. The issue im having is i want to format the {DATE}tag to be dd-mm-yyyy without the addedd seconds it puts at the end as in the below example

What it should show as the date is 27-08-2000

and not 27-08-00 00:100:

This is the format so far [=ADM('{DATE}',-216)] which gives the below output, im struggling to work out where to add dd/mm/yyyy into the format

[Jesse]

Try {DATE:mmDDyy} syntax may be off a little.

[RickH]

Already tried that and doesnt work, the output shows nothing. I think normally that works but because ive got -216 to deduct 216 months off its throwing the formatting out

[emre]

Did you tried FD function?

Age Verification or 18+ reminder with calendar

Sure. Use this formula: [=FD(ADM('{TICKET DATE}',-216),'dd/MM/yyyy')] ADM function adds Months, so 18 years x 12 months = 216 months. In this case I used -216 (negative) to subtract months from current ticket date. This is 1 solution that could be modified to suit your needs. [image] [image] Ensure you add a Default mapping to the following Rule: [image] MessageToDisplay: Customer must be Born on or before this date: [=FD(ADM('{TICKET DATE}',-216),'yyyy-MMM-dd')] [image]

[RickH]

Thanks emre I’ll try this tomorrow, I missed this when searching