When i run this (screenshot bellow) is changes both the date and time in the data base. But I want it to only change the date, how is this done?
You can set the time to anything you want…
Consider Time-of-event
= This Event's Time-of-event
change date to
Current cells's date:extract date
.
Didn’t test it, but might work. If it doesn’t, just change each component - year, month, day separately.
Just tried your solution it works perfectly. Just one question though if i use
It only changes the date right. But I want to change the year, and month would I have to repeat this expression two more times with extract month and year at the end
Yeap, wrote from mobile and didn’t remember whether date is a full date or just day of month. If it only changes day, just repeat the same for month and year.
Thanks for the help mate
1 Like