Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to comapre the end date field with the current week's date i.e., i want to display 'Y' if the end date is within the current week else 'N'.could you please let me know how this could be done
Several ways are there, you can try:
If(Week(today())=Week(End Date), 'Y','N')
Thanks