Default date field to yesterday

[BrianI]

Hi

I am able to set a date field on a datapage to today's date by setting the field's External Parameter to [@cbTimeStamp*] but what I need to do is set it to yesterday. So something like: Dateadd(day,-1, '[@cbTimeStamp*]') but you can't put a formula in the external or default parameters. Does anyone know of a solution for this?

Thanks

[BrianI]

In case anyone else has this requirement I used some script in the end...

 

<script>

// Get today's date
var today = new Date();

// Calculate yesterday's date
var yesterday = new Date(today);
yesterday.setDate(today.getDate() - 1);

// Format yesterday's date as mm/dd/yyyy
var month = yesterday.getMonth() + 1;
var day = yesterday.getDate();
var year = yesterday.getFullYear();

var yesterdayFormatted = month + '/' + day + '/' + year;

// Set the value of the date input field to yesterday's date
document.getElementById('cbParamVirtual12').value = yesterdayFormatted;

</script>