Hi, I have a date field and I want to create another field which only has the 1st day of each month in it. How do I script it? Thanks.
MonthStart(YourDateField) as FirstDateofMonth
Many ways are there:
Best is to use QV function MONTHSTART
Retrieving data ...