Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
year function picking up '2068' value from 68 but it should be '1968'
I have attached the Captured Image.
You can check like this
If(Year(birthDate) > 2000, Year(birthDate)-100, Year(birthDate)) as BirthYear
I am not sure what Year is needed as what... but you can make this smart like this
If(Year(birthDate) > Year(Today()), Year(birthDate)-100, Year(birthDate)) as BirthYear
Anything before 2019 will show up in 2000s and anything after will be from 1900s.
You can fix the Year by subtracting 100 from it....
Year(birthDate) - 100 as BirthYear
Do you also want to fix birthDate?
But now year 69 is shown as 1869.
You can check like this
If(Year(birthDate) > 2000, Year(birthDate)-100, Year(birthDate)) as BirthYear
But I want 01 as 2001 then...
I am not sure what Year is needed as what... but you can make this smart like this
If(Year(birthDate) > Year(Today()), Year(birthDate)-100, Year(birthDate)) as BirthYear
Anything before 2019 will show up in 2000s and anything after will be from 1900s.