I wrote a calculation(analog) tag to show datetime and that value will export to excel but excel is cutting the last 3 digits.
I used the following expression, and it gives the value 202310282319 which i need to process in excel but that's fine.
CONCAT(Date(Today(), "yyyyMMdd"), "", Time(Now(1), "HHmm"))
- Giving hyphens between dates don't work for analog tags. I cannot change to string types because I am generating "analog summary report" and all other tags are analog tags.
For the tag Date_Time_Gas_Run_Start, using yMMddHHmm instead of 4y gives 23 for year 2023 but even so the minute is still not showing fully. Then I put decimals in tag property just because.
My question is why this is not working. And do i have to use 2 tags? 1 for date and another for time?!