Forum Discussion

DavidB023's avatar
DavidB023
Helper III
8 years ago

Put a year into date

  Hi everybody !   I have a problem with date value. My table are like this, my problem is on Date column :     And I just want to put a year at its end... I look for a function which...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Could you please post the source data format? Are you able to change the type to DATE in Query Editor?

 

Thanks

Raj

DavidB023's avatar
DavidB023
Helper III
8 years ago

Here is my source data test : https://1drv.ms/u/s!AlpYVjQtU7WhiS1xfWK_pBilOtGO

My basic format for Date column is text first, when I change it in Date format, I have every date in 2018..but when you see my source, (and it isn't practical) I have on a same column each day of each month for 3 years ago but without year's information.

Thanks

David

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I could not access the file due to firewall issue, hope someone see the file and responds to you.

     

    Thanks

    Raj