Syntax for Year checking and Processing Date

I have a scenario like, I am getting a date field from input in MMDDYY format and I have to check for same year as processing year then I should pass "", else if the input date is to previous year to processing date and less than 0301 then I should pass Y.
How to check and process the date?

Interview Candidate
Apr 4th, 2016
2
8053

Abinitio

Answer

Showing Answers 1 - 2 of 2 Answers

mohankrishna

Apr 8th, 2016

Use date function to get the current date and apply date_year function to get the processing year out of it.
Do the same for input date to get the input year.
If these two are equal set " " to output. Now to check input date is previous year and difference is less than 301 days, use the date_time_difference function to check the difference of days between input date and current date and assign the output accordingly.